if you have 2 dbs and need to join tables between the 2 dbs how could this be done? would you have to declare 2 object variables as databases, and then open two databases? How would you get a recordset that displayed the data from the 2 opened dbs?