Single query referencing tables in multiple MDB files

[sasharad]

Is it possible to create a query in one Access MDB file that references tabels in other MDB files?

[FishVal]

Sure.
You may:

• link external tables to mdb there the query is located
• use "IN" clause in the query SQL expression to specify path to mdb where source/target tables are located

Regards,
Fish

[sasharad]

Sure.
You may:

• link external tables to mdb there the query is located
• use "IN" clause in the query SQL expression to specify path to mdb where source/target tables are located

Regards,
Fish

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?

[FishVal]

Read Access help "IN Clause" topic.
I think that would give you enough information to start playing with it.

Best regards,
Fish