join between 2 disconnected recordsets 
Author Message
 join between 2 disconnected recordsets

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?



Sent via

Sun, 27 Jul 2003 23:49:48 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Disconnected Recordset: Not editable SQL-JOIN used

2. Disconnected recordsets deleting data from joined tables

3. Disconnected Recordset: Not editable SQL-JOIN used

4. Join together disconnected recordsets with SQL statement

5. Disconnected Recordset: Not editable SQL-JOIN used

6. ADO fails to release Recordset cursor after opening disconnected Recordset

7. Creating a new recordset by joining 2 existing recordsets

8. Disconnect recordsets on forms

9. Disconnected Recordsets in ADO.NET?

10. disconnected recordset.

11. How can I creat an Identity field in a Disconnected Recordset

12. referencing fields in a disconnected recordset


Powered by phpBB® Forum Software