Run query residing on external database

[Guest]

I have three queries and a table residing on an external database. The table
is linked and I would like to be able to run the queries without importing
them to my current database. I'd like to implement the same code using the
same 3 queries on 3 separate databases. It would be great if i didn't have to
have a copy of the queries in each DB.

Thanks in advance,

Pip'n

 

[MGFoster]

I have three queries and a table residing on an external database. The table
is linked and I would like to be able to run the queries without importing
them to my current database. I'd like to implement the same code using the
same 3 queries on 3 separate databases. It would be great if i didn't have to
have a copy of the queries in each DB.

I'm assuming that the external DB is an Access DB? If so, use
Automation to run the queries in the other DB. See the Access VBA Help
article on the GetObject() function.