T
TB4300
Hello!
I was able to link to Exchange public folders by shutting down Access after
each connection attempt. Without closing Access, I received "Microsft
Exchange Server is currently unavailable. The wizard can't access it."
The same issue (maybe?) appears to be impacting my ability to execute UNION
queries to combine these emails into one table. Each attempt results in "The
Mircrosoft Jet database engine cannot find the imput table or query
'BlanketClientApproval..." Although, this is the table name. Here's the
UNION query:
SELECT * , "Contract" as [Email Type]
From [Contracts]
UNION ALL
Select *, "Approvals" as [Email Type]
From [BlanketClientApproval]
UNION ALL Select *, "Site" as [Email Type]
From [CompanySiteNew];
The UNION works if its redirected to IMPORTED tables rather than the linked
versions. Any ideas why?
I was able to link to Exchange public folders by shutting down Access after
each connection attempt. Without closing Access, I received "Microsft
Exchange Server is currently unavailable. The wizard can't access it."
The same issue (maybe?) appears to be impacting my ability to execute UNION
queries to combine these emails into one table. Each attempt results in "The
Mircrosoft Jet database engine cannot find the imput table or query
'BlanketClientApproval..." Although, this is the table name. Here's the
UNION query:
SELECT * , "Contract" as [Email Type]
From [Contracts]
UNION ALL
Select *, "Approvals" as [Email Type]
From [BlanketClientApproval]
UNION ALL Select *, "Site" as [Email Type]
From [CompanySiteNew];
The UNION works if its redirected to IMPORTED tables rather than the linked
versions. Any ideas why?