Union Query fails

[RitaHH]

I Can run this query on my computer but not on another computer using my same
login. Runs for a while then fails with "The Microsoft Jet Database engine
could not find the object "". Make sure the object exists and that you spell
its name and path name correctly. MDAC, Windows, Office versions are all
the same.

 

[S.Clark]

Perhaps the local .mdb / .accdb file is corrupt on that machine. Repair and
compact, or replace with a copy from the computer where it works. ??

 

[Alan]

I Can run this query on my computer but not on another computer using my same
login.  Runs for a while then fails with "The Microsoft Jet Database engine
could not find the object "". Make sure the object exists and that you spell
its name and path name correctly.   MDAC, Windows, Office versions are all
the same.

You can create a new, empty database. Go to File menu-> Get External
Data-> Import. Now you can import every valid table. This will give
you a clean set of systems tables; If this still does't work, I think
you may need some professional services. You can try Advanced Access
Repair at http://www.datanumen.com/aar/ It recovers several
important Access MDB files for me and is really helpful! Good luck!