Inner Join on tables in different databases

J

Jeff Boyce

If I understand your question correctly, you could link (Files | Get
External Data | Link...) tables into a database (one of the "separate mdb
files", or a new one), then build a query.

Good luck

Jeff Boyce
<Access MVP>
 
J

John Vinson

How to inner join tables which are in separate mdb files?
Click to expand...

You can create a Query with an inner join, by using File... Get
External Data... Link to link to the second database; just create a
query with the two tables and join on the appropriate key field.

You cannot, however, use the Relationships Window to enforce
relational integrity between the two tables.
 
Top