Inner Join on tables in different databases

  • Thread starter Thread starter Shreenivas Potnis
  • Start date Start date
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>
 
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.
 
You must log in or register to reply here.

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
specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen 1
Delete query with joined tables 0
An Inner Join on an Inner Join 1
How do you ignore entire tables in an Inner Join Query? 13
Cannot modify record based on multiple table query 3
INNER JOIN performance issue 5
Nested JOIN clauses - order of precedence (Access 2007) 2

Back
Top