running queries from another database

[adamgilb]

Hi,

I have several make-table queries in different databases that when run all create tables in a common database. I want to create a macro in this database that runs all these make-table queries at once so that the tables are kept up-to-date. In other words, how do I run an action query that exists in one database from another database? Is this possible?

Thanks

 

[FoFa]

I have several make-table queries in different databases that when run all create tables in a common database.Thanks

Why not link the tables to your Common DB and run the macros from that one? Or just use the linked tables?