"Remote query" on DB open

[don1980]

I am trying automatize the update of several tables residing in a few different databases.

I would like to be able to open one database that then launches the update of several table creating queries in other databases.

My experience with vba for access is limited, so I was wondering if such a thing was possible?

 

[Tidy]

I believe what you are trying to do is possible. You would have to create a database connection to all the seperate databases. I would try making the connections using "DAO" connections.