Solving Problems with Library References

[Informatic]

Installing or uninstalling any software may overwrite, remove, or de-register libraries.
How can I reference some libraries (like DAO) to an Access project .
I want to do this with VBA ,when the user start the database.

Help..............

 

[oharab]

If you are having problems with references on different machines, then don't use them!
Dim things as Objects then create them:

Dim xl as Object
set xl=CreateObject("Excel.Application&quot

or

Dim dbEngine as object
set dbengine=CreateObject("DAO.DBEngine.35&quot

and so on. It takes a small performance hit, but has got to be better than messing around finding out which references are available and which aren't!

HTH

Ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------