Solved: Join Tables in Tow different Databases

[kbsudhir]

Hi All,

I want to join two tables residing in two different databases in a query.
Ex. Table "A" in Database "1" has to be joined with Table "B" in Database "2".

1. Is it possible....???? :dunno :dunno
2. If Yes, then please guide.

:banghead: :banghead:

Regards
Sudhir

[CreganTur]

You need to create a linked table in the database you are working with. Once you have established the link, you can run a joined query with no problems.

From the main Access Toolbar click File-> Get External Data-> Link Tables. Follow the prompts to create a linked table.

[kbsudhir]

Thanks Randy,

I have a query here. Will the linked table will get updated every time I there is any updates done to the original table.

Regards
Sudhir

[CreganTur]

Will the linked table will get updated every time I there is any updates done to the original table.


Yep. That's the beauty of linked tables- you have a direct connection to the real table (unlike making a copy of the table), but without the overhead of having the table being held within your database.

[kbsudhir]

Thanks Randy.