Query a table in another Access database (Access 97, SR2)

Topic

New Reply

I am trying to figure out the best way to bring information from one Access database into another. One database has a query that creates the information that another user needs to make use of in another Access database. I would prefer to make this so that the second database can run the query in the first database and have the results placed into an existing table in the second database. Any thoughts or suggestions are certainly welcome and appreciated. Thanks!

Reply | Quote

Replies

Put the same query in both databases and link the source tables for it. If this is a make-table query, the table will be created in the database it’s run from by default.

Reply | Quote