Query two db's

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
I use Access as a front end for SQL. Both DB1 & DB2 are SQL tables.
DB2 is a historical copy of DB1.

Thanks
 
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.
 
Back
Top