passthrough query referencing a saved table

J

joemeshuggah

is it possible to use a table saved in an access file as a filter for a
passthrough query that retrieves data from a server?

e.g.

select odbc.col from odbc.tbl
where odbc.col in
(select mytbl.col from mytbl.mdb)
 
J

John W. Vinson

is it possible to use a table saved in an access file as a filter for a
passthrough query that retrieves data from a server?

e.g.

select odbc.col from odbc.tbl
where odbc.col in
(select mytbl.col from mytbl.mdb)
Click to expand...

No, because the server has no way to look inside your computer and see what's
in mytbl.

You will need to construct an IN clause containing the actual mytbl.col
values, or come up with some other way to build the link.
 
Top