Query two db's

[Guest]

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?

 

[[MVP] S.Clark]

Is this in Access or SQL Server?
Is 'database' a database or a table?

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Guest]

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

Thanks

 

[[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.