Automatic Link to DAO 3.6 Object Library

[SDTEAM]

If this post is in the wrong place please feel free to move it. My Question concerns MS ACCESS and the DAO 3.6 Object Library. The Version of Access in use is "Microsoft Access 2000 SR1".

My database resides on a server and people can log in to the database from terminals which may not have "MS DAO 3.6" linked as a reference within the version of Access installed on the terminal. How can my database (on opening) check the machine it is opened on, to see if that machine has the "Microsoft DAO 3.6 Object Library" linked as a reference. And if DAO3.6 is not linked, to set up a link.

Currently I have to manually set a link from tools/references within the VB window on any Terminal that opens the database. I need this DAO library linked for the database to work properly.

any help is appreciated, thank you

 

[antomack]

Take a look here
http://support.microsoft.com/kb/194374

 

[SDTEAM]

Thank you, that looks like it will do the job. very much appreciated