How to link to external query?

[Kennie]

Want to link a query from Database01 to Database02. Is that possible?

 

[aaron.kempf]

Jet doesn't support temp tables.
it only supports persistent tables.

Move to SQL Server, you can automagically link to (or call) queries in
other databases

-Aaron

 

[Tony Toews [MVP]]

Want to link a query from Database01 to Database02. Is that possible?

Assuming that you want to execute a query present in database01 against a table in
Database02

See the IN Clause

IN Clause
Identifies tables in any external database to which the Microsoft Jet database engine
can connect, such as a dBASE or Paradox database or an external Microsoft® Jet
database.

Syntax
To identify a source table:

FROM tableexpression IN
{path | ["path" "type"] | ["" [type; DATABASE = path]]}

Please ignore Aaron's posting as Aaron's answer to just about every question is SQL
Server and ADPs. No matter how appropriate his response.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/