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?
Printable View
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?
You can import / link the tables you need from the first database to the second one and then use them as if they were belong to the the same database.
Since I don't know what database type you are using (Access, SQL Server, Oracle, etc), I am not sure if you can use both of the ways, one of them or no one. I know that using Access, you can use both of them.