Add Object Libraries with code

[Teebird]

Is it possible to run a piece of code that will add the relevant references to Access on opening the database.

The code would check that these references are ticked.
VB for Applications
MS Access 10 Object Library
OLE Automation
MS DAO 3.6 Object Library

Many thanks
Tee

 

[allan57]

check out this link:

http://www.access-programmers.co.uk/forums/showthread.php?t=77167&highlight=set+vb+reference+code

 

[Teebird]

Excellent - had a look at this link - do I have to add a SetRef for each of my references.
Run Code
SetRef("Access","c:\program files\commmon files\microsoft shared\VBA\VBA6\VBE6EXT.OLB")
Run Code
SetRef ("Access","c:\program files\common files\microsoft shared\DAO\dao360.dll")

etc...