I have opened two MS Access databases using VB6 and ADO. So as not to 'disturb' the two original databases, I will create a third database (also MS Access) to hold a massive table resulting from a long SQL statement that will draw from many, but not all, tables in the two databases. How do I reference these databases and the tables in each in a SQL statement to create the new table in the third database? I know I can copy tables from each of the two databases to the third and work within the single database, but I'd rather not (unless that is my only option).
Jim
PS If this post appears twice, sorry for that, but something went haywire when I submitted this the first time.
Jim
PS If this post appears twice, sorry for that, but something went haywire when I submitted this the first time.