MS Data Access Components

[krisleech]

I am developing a database using Access 2002 set to use the Access 2000 file format, however the target machine which the database is for use on has Access 2000, but different MDAC versions.

The cause of errors is the MS Access 10.0 Object Libary.

The target machine has MS Access 9.0 Object Libary, and as result functions like date(), Left() and Format$() all fail.

What would the best approch be when distributing the database?
All i can think off is to include a copy of MS Access 10.0 Object Libary so users can update there files if needed.

Would this be a workable idea and if so where can i download version 10.0 object libary?

Any advice would be great, Kris.

 

[Autoeng]

I don't know if the A2K machine will be able to reference the library but to get a copy of the Object Library on the A2002 machine jump over to the VBA window, select Tools, References, select the reference that you are looking for and it should list its location in the window below the selection pane. Copy it to the directory where the db will be on the A2K machine. On the A2K machine go into the VBA window, select Tools, References, Browse and point to the location where you placed the library. If this is going to be an issue for several machines you might consider locating the library on a shared directory and pointing the db, no matter what version of Access, to that location.

Autoeng

 

[Autoeng]

Wow, I didn't know that. Good call Pat.

Autoeng