Use Pass through with another Access database

  • Thread starter Thread starter ScottS
  • Start date Start date
S

ScottS

Is it possible to create a pass-through query against a table in another
Access database?

Thanks!
 
You should be able to create a query like:

SELECT Employees.*
FROM Employees IN '\\ServerName\users\xxx\Data\Access\Northwind.mdb';
 
Is the table in the other Access database a table in the database or a link
to some table in SQL server?

You can use the following SQL structure to get data from a table in another
Access database

SELECT * FROM tblReports in 'C:\Center Databases\ProjectTime.mdb'

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Thanks for the help. This worked well.

Does Access process queries in the form more efficiently than if the table
is actually linked?
 
Thanks for your help. The table is an Access table in database located on
another server. I tried your approach and it worked out well.
 
Back
Top