Create one DAO.Recordset from several

K

Kristian

Hello,
Is there a fast way to create a large recordset
from several or do I have to loop through each recordset?
I create one recordset from each selected mdb in a list
box and want to combine those "part recordsets" to a
"total recordset" consisting of all the records from each
one.

Grateful for any tip!
Regards,
Kristian
 
V

Van T. Dinh

Perhaps creating a Recordset based on a UNION Query which combines Records
from different Tables.

Check Access Help / JET SQL Reference on the UNION Query.
 
G

Guest

No,
Since the recordsets come from different connections I
don't think it works.

Kristian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Automate Word mail merge from AC2007? 0
A theoretical question: how best to manage perpetual recordset needs? 24
Append externally sourced recordset to local access database 0
Recordset with SQL strings 1
Creating a single flat record from a one to many query revisited 1
Iterate/loop through a form to copy value from one control to anot 2
Loop through recordset and create excel spreadsheets 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top