Ok, the answer (I just found out) is that you can only reference ONE database in a query....at least as far as VB and Access are concerned.

Once you have referenced the first database (IN .....) you are stuck with the tables/queries that exist there. Obviously this does not address the linked tables.

For an interesting experience try this in a blank sql qrid in Access:

SELECT Declares.Name INTO [Temporary Table]
FROM Declares IN 'C:\open.mdb';

Now click the blue title bar and select "query design".
Now select the Query->Show table from the menu.

The only tables you have access to are the tables in the foreign database.

Weirdness...I don't do weirdness....

DerFarm