Run a routine from one database to affect an external database

[BMunny]

Hi

I have many databases that have a reference to the DAO
3.51 library and I want to change it to reference the DAO
3.6 library. I've built this routine and stored in an
another database. I want to use this database to open the
databases and run this routine to change the reference in
the external databases. Is this possible?

Any help would be great!
Thanks in advance!

 

[david epsom dot com dot au]

You have to create an Access.Application object, and set
the current database of that Access.Application object.
Then you can use methods and properties of that Application
object, including the stuff dealing with references in
the current database.

It is very difficult if you have secured databases: other
wise it is pretty straightforward.

(david)