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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

perform INNER JOIN on query results 2
Help creating a search form in Access XP 0
An Inner Join on an Inner Join 1
How do you ignore entire tables in an Inner Join Query? 16
Nested JOIN clauses - order of precedence (Access 2007) 2
Wildcard on an "INNER JOIN" 5
Inner , Right, Left JOIN 15
String Manipulation in an Inner Join 1

Top