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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on Pass-through Query 4
Pass Through Query - not returning rows 1
Pass through query and variables 2
How to Retrieve Data From Another Access Dataase Without Linking to It? 1
Is It Possible To Pass Parameters to A Pass Through Query 3
Pass Through Query using Local Access Table 1
How to execute a pass-through query from a remote computer 0
Pass-Through Question 3

Back
Top