Thank you. I don't know the name of the table in advance so the first method did not work for me.
I did not know that IN clause with a file name is allowed. That would solve my problem. Does it have to be an absolute path? Does Access support relative file names or has a search path that can be specified?...
sasharad
Last Activity: Mar 23 '08, 12:24 PM
Joined: Mar 22 '08
Location:
-
Single query referencing tables in multiple MDB files
Is it possible to create a query in one Access MDB file that references tabels in other MDB files? -
Single ResultSet from multiple data sources
Is it possible using ADO from ASP pages to get a single ResultSet with data from two different mdb files?
No activity results to display
Leave a comment: