Problems using UNION with linked Exchange tables

[Peter]

I have 2 linked exchange tables in my database. These are linked to contact
folders on my exchange account.
I can query these tables one in a time, but when I use a SQL statement

SELECT DB1.*
FROM DB1
UNION SELECT DB2.*
FROM DB2

Acces gives an error, that it cannot find table DB2, although it is linked
under this name. Further testing with other linked tables did not solve the
problem. The second table was not found.

Does anyone know hiw to solve this?

Peter

 

[David Cox]

I am not expert in UNION queries, but try:

( SELECT DB1.* FROM DB1)
UNION
(SELECT DB2.* FROM DB2);