In looking through previous discussions, I've seen you cannot do a join
between 2 tables on different Access databases.  The solution has been
to put a link to the second table on the first Access database and do
the join that way.  This is what we are currently doing, but since our
databases reside on different servers, we are getting a hit on speed.

One suggestion was to see if we could do a join on 2 disconnected
recordsets where recordset A is from the first database and recordset B
is from the second.

Is this possible?

Thanks,

Peeter

Sent via Deja.com
http://www.*-*-*.com/