link to a query in a second database

[asc4john]

I am tring to link to a query in a second database using this info but
not having any success.

http://groups.google.ca/group/micro...&lnk=gst&q=link+query&rnum=9#76fe04b5b97bd069

It says to create a make table query and link to that table. Link to
the table after running the query? That would mean running the query
each time, not what I want. Link to the Make Table Query? It doesn't
show up in my list of avaiable links.
How do I do this?

 

[Guest]

Of course the query has to run each time. How otherwise would it reflect
changes in the tables since the last time it ran?

-Dorian

 

[asc4john]

The post seems to imply that the query does not have to be run each
time. That you "can" link to the query because it is a "Make Table"
query. Otherwise what is the point?
Bascically I want to link to a query in an other database, How do I do
that?

 

[Pieter Wijnen]

You can create a local query

SELECT * FROM MyRemoteQuery IN 'C:\RemoteDatabase.mdb'

Or

SELECT * FROM MyRemoteQuery IN [C:\RemoteDatabase.mdb]

This method can also be used for text , Excel & ODBC files Albeit with a
more complex connection string

SELECT *
FROM
[Text;Database=C:\Temp\;TextDelimiter=none;ColNameHeader=True;Format=TabDelimited;].[MyFile#txt];

Note the use of # instead of (.) before the file extension

HtH

Pieter