Hello,

I have 2 databases (Access MDBs) and I need to do a select which joins a table from each database.

So I have l_rstTable1 and l_rstData2 as recordsets in my code. I need to create another recordset that is based on a join between both of the underlying tables of l_rstTable1 and l_rstTable2.

Is there an easy way to do this? I was thinking that I might need to copy one of the tables into the second database temporarily in order to do the select. Or can I make a link to one table?

The location of the databases can change and so creating the link needs to be done at run-time once the databases have been opened.

TIA

Pete