Join between different DB files

[gmaster]

Hi everybody, i'm here again asking for your precious help in this particular matter: is it possible to create an inner join between tables from two different access files??

More specifically, i have a query more or less like this one:
UPDATE T1 INNER JOIN T2 ON T1.B1 = T2.B2 SET T2.A2 = T1.A1 WHERE Transfer = TRUE ("Transfer" is a field in T1 of the YES/NO type)


As u can see, T2 updates itself with values from T1 depending on the validation of the Transfer field.... but how can it work if T1 and T2 are tabs in two different access files??
Thanks for reading!!

[JoeM]

You can "link" an Access table in another database to your current database.
You just follow the same procedure you would to import an Access table, except select "link" instead of "import".
You can then use that table from your other database in your query.

[gmaster]

I love you! Marry me!!! It works!

[JoeM]

Glad it works out, but sorry I am already married!