Get single ADO Recordset from multiple Access Databases
 

Hi:

I'm currently using an embedded MS Query to populate a temporary
spreadsheet, then using the resulting rows to populate other spreadsheets,
then removing the temp sheet. I would rather use an ADO recordset to
accomplish the same thing and not have to manipulate a temp sheet.

Problem: The embedded query links two separate Access databases and uses
tables from each in a single Join SQL statement. I've not been able to set
this up using ADO connections, and have found nothing on the forum addressing
this specific situation. Can it be done?

Thanks in advance!

Greg

Get single ADO Recordset from multiple Access Databases
 

The example by Steve Brown should get you pointed in the right direction.

http://www.interaktonline.com/Produc...databases.html

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pontificateur" wrote:
Hi:

I'm currently using an embedded MS Query to populate a temporary
spreadsheet, then using the resulting rows to populate other spreadsheets,
then removing the temp sheet. I would rather use an ADO recordset to
accomplish the same thing and not have to manipulate a temp sheet.

Problem: The embedded query links two separate Access databases and uses
tables from each in a single Join SQL statement. I've not been able to
set
this up using ADO connections, and have found nothing on the forum
addressing
this specific situation. Can it be done?

Thanks in advance!

Greg