passthrough query referencing a saved table

[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)

 

[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)

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.