You may want to look into SHAPED recordsets.  They may
give you the functionaliy that you need.

Cardyin

---------------------------------------
Cardyin Kim
Client/Server & Web Development Analyst
Information Services
San Antonio Community Hospital
ckim@s...     (xxx)xxx-xxxx     
---------------------------------------


-----Original Message-----
From: Ian Oates [mailto:ian.oates@u...]
Sent: Thursday, October 25, 2001 7:58 AM
To: professional vb
Subject: [pro_vb] 3 Access dBs and ADO Connections


I have three separate MS Access databases and three ODBC DNS 
strings, 'Local', 'System' and 'Archive'.

Historically when all the tables were in one MS Access dB no problem. I 
set the DNS and execute a SQL statement to return a recordset.

What I want to do now is the same (but the 3 Access databases are in 
different locations) but open two/three connections, execute a SQL 
statement which would use two or three databases and return a recordset.

Any help appreciated
Ian Oates