Let's assume that;
- MyTable1 is in DBFile1.mdb
- MyTable2 is in DBFile2.MDB
- You want to run the query in DBFile2.MDB.
You can attach MyTable1 to DBFile2.MDB with the following code and run any query that refers both MyTable1 and MyTable2.
Dim tdef As New TableDef, db as Database
Set db = Workspaces(0).OpenDatabase("<Path of DBFile2.MDB>", False, False, ";pwd=<password>")
thnks for your answer, but will the processing speed be a factor when i had thousands of records in a single table? Also, i am currently using adodb.recordset in creating queries, is there any versions of your code to adodb.recordset?
thanks for your time...
Give me a place to code and i shall move the earth!