Hello all..

I'm trying to connect 2 tables (using INNER JOIN statement) in 2 files using ADO.

For example, I want to join table DATA1 in A.mdb with table DATA2 in B.mdb.

I have made 2 ADO connections:
con1 for A.mdb
con2 for B.mdb

I have done this:
DIM rst as NEW.ADODB.RECORDSET

rst.Open "SELECT data1.custID, data2.orderID FROM data1 inner join data2 on data1.custID = data2.custID", {active connection}
how do I set the active connection for the recordset?


thank you very much