Using MS Access 2000 as an ADD-INS!

[Atajames]

Hi ALL,
I trying to write a program and the database I'm using is MS Accesss 7.0. However, I need some functionalities on MS Access 2000. When my database was converted in Access 2000, the program could not recognize it. What should I do? Please let me know.

James!

 

[zemp]

What are you using to connect to your database, ADO or DAO? In either case you may need to upgrade you connection objects. Access 2000 uses the Jet 4.0 engine, so if you are using DAO make sure that you have a refence to Jet 4.0 and not Jet 3.5. If you are using ADO you may have the same problem. I find that ADO 2.5 works well with Access 2000. Check your reference. You can download upgrades from microsoft.

If I have guessed incorrectly then post more details with some code and we'll help you out. Thanks and Good Luck!

zemp

 

[tedsmith]

Ive used ADODC and dataenvironment to read Access2000 OK but you have to change the DAO reference to 3.6 in References