DAO Object Librarys

[Jozshi]

Hey People!

Just wondering if anyone can help with this 'sort of problem' that I am having.

It involves different versions of the DAO Object Library, and how it brings up errors.

Basically this small application that I wrote for a friend uses it on 5 different systems. Two of the systems use the DAO 3.6 and the rest use 3.51, but it errors between the versions due to the 'so-called-correct' version being ticked. This means that when I give them an update I need to manually go to the systems and check each one, if it brings up an error then I change the DAO Objects to the correct one.

This may all be nothing and I am a lame knowledged programmer (im new to VBA), but does anyone know a way round this. Example, do I need to work in DAO version that all their systems support etc etc..

Many thanks!

- F8i

 

[nickjar2]

Jozshi,

If all users are using Acc 2000 then they all should be using the DAO 3.6 obj library. What error do you get if you use 3.6 for all db's?

Nick

 

[nickjar2]

Also,

Goto help, and in the answer wizard type in "dao object library compatibility".
This might help. I got this from the MS website doing a search on DAO (in knowledgebase).

Nick

 

[Jozshi]

This is all based on Access 97. Although some systems had Access 2000 previously installed on them, but which have now been removed (thank god!).

I will check out the help, but if I remember rightly it didnt seem to shed any light on the idea.

Any other help welcome ppl

Thanks Nick!

- F8i

 

[nickjar2]

If all are runnung 97 then I think you can just use the DAO 3.51 library.

Nick

 

[Databaseguy]

97 Used 3.51, 2000 uses 3.6. Perhaps you should convert to ADO ?? Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy