query different connections with one recordset

with DAO and access it is possible to do innerjoin select sql queries with tables that are not in the same db.

e.g.

SELECT tbl1.*, tbl2.* FROM " & db1.name & ".tbl1 INNER JOIN " & db2.name & ".tbl2 ON tbl1.c1 = tbl2.c1;

this works perfectly. but what about when you do this in ADO? There you don't have a db and therefore no db.name. help would be grately appreciated

Christian Received on Fri Feb 02 2001 - 06:40:41 CST