Reference Trouble

[NJudson]

I created a dbase on one pc using Access 2k and set one of the references to "Microsoft ActiveX Data Objects Recordset 2.7 Library". When using the dbase from different computer there is an error. This error is because the version of Access 2k on the 2nd computer is out of date. It only has "Microsoft ActiveX Data Objects Recordset 2.5 Library" reference. So whenever the program is used on the 2nd computer I have to delete the Missing 2.7 library reference and add the 2.5 library reference. This works fine until I then run the program on the 1st computer which resets it back to 2.7 library. I know all I need to do is upgrade the version of Access 2k on the 2nd computer but if I don't is there a way to keep this conflict from occuring everytime the program is used on different computers. Thanks.

 

[Nero]

Another option would be to just register the 2.7 .tlb file on the second computer.
Copy the file to C:\Program Files\Common Files\SYSTEM\ADO
and then use regserv.exe to register it.
I don't think there is an easy answer to your problem.

 

[NJudson]

Thanks Nero. I copied the ADO over to the 2nd computer but did not run the regserv.exe. When using on the 2nd computer it uses the 2.5 library without manually setting it to that and when I then go to use it on the 1st computer it shows 2.7 library. Although the 2nd computer isn't using 2.7 it does seem to work ok with no errors and for all intensive purposes that's fine by me. Thanks again.