Re: Joins with Multiple Database Files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Stephen wrote on Tue, 25 Apr 2006 19:34:53 +0100:

I am using a few Access database files with related data and I would like
to
use a join on them. Is it possible to use a join with tables in two
different
Access database files? I have never heard of this being done, but it
would greatly help. I would like to avoid joining the data by my own
code, but I could if needed. It would obsiously be much faster to use the
SQL join if
it
can be done.

I don't use Access but I believe you can. What you want to do is link 1
Access database from the other.
Having done so, you should be able to do a JOIN and get results in 1
Recordset

Stephen Howe


That's the only way I've managed it in the past too.

The following link has a way to manage this dynamically:

http://www.vb-helper.com/howto_join_two_databases.html

However, if 2 or more concurrent users run the same code then they will
conflict with each other, so the table name for the linked table needs to be
dynamic. It's also messy have things being created on the fly like this -
much easier to define the linked tables in the "master" database and leave
it that way.

Dan


.