• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Is it possible to join 2 tables from 2 different access databases?

Is it possible to join 2 tables from 2 different access databases?
0
silentthread2k
Asked:
silentthread2k
4 Solutions
 
Rey Obrero (Capricorn1)Commented:
the easiest way, assuming dbA and dbB
create a link from tables in dbB in dbA , or vice versa
you can then treat the link table like local table in your query
0
 
EirmanChief Operations ManagerCommented:
You could import a table from one database into another and work from there .... or you could import both of the tables into a new database
0
 
silentthread2kSenior Software EngineerAuthor Commented:
How do you create a link?
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
Kuwait10Commented:
Yes, it is possible by using a linked table .
0
 
Rey Obrero (Capricorn1)Commented:
for A2003 or lower
File > Get external data > link
  locate the other db and follow the wizard, select the tables

for A2007 or A2010
from ribbon
 
External Data > Access

0
 
aikimarkCommented:
In addition to linking one of the tables to the other's database, you can also write a query that references the external (not attached) table using the IN keyword.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now