Query an Access Query in another database

[bconner]

What is the syntax for quering a query in another access database? I am
wanting to query several queries in several different access databases and
pull them together using a Union query.

 

[Jeff Boyce]

You might try something like:

SELECT *
FROM QueryName IN '\\server\path\AccessFileName';

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lou]

What is the syntax for quering a query in another access database? I am
wanting to query several queries in several different access databases and
pull them together using a Union query.

A table in a remote database can be referenced by specifying its name
and file location.

SELECT AddressStreet, AddressCity, AddressState
FROM Table1 IN "E:\ACCESS\FirstDB.mdb"
UNION ALL
SELECT AddressStreet, AddressCity, AddressState
FROM Table2 IN "E:\ACCESS\SecondDB.mdb"

To avoid using the "IN" clause, employ the menu items

GetExternalData
and
Link Tables

If done in this second way, all that needs to be referenced is

SELECT AddressStreet, AddressCity, AddressState
FROM Table1
UNION ALL
SELECT AddressStreet, AddressCity, AddressState
FROM Table2