Query two db's

P

phil1955

Is there a way to query one SQL database for ex: Customer name, balance etc
and query a second SQL database to pull some historical data ie: Customer
balance based on the criteria set in the first query?
 
P

phil1955

I use Access as a front end for SQL. Both DB1 & DB2 are SQL tables.
DB2 is a historical copy of DB1.

Thanks
 
M

[MVP] S.Clark

If your Access file is an mdb, then you can link to the differet SQL db's.
If you have an ADP, then it's dedicated to that one mdb.

Maybe in a Stored Proc you can create a query to hit different db's.
Otherwise, maybe a small DTS package to transfer data from one db to another
on a regular basis.
 
Top