Access generates errors trying to run/design a query

G

George Wilson

I am currently assisting a customer using Access 2002.
When I try to run a certain query, run a report based on
this query or open the query in design view, Access then
generates an error and shuts down. Other queries and
reports work fine. I checked the Jet engine and appears to
be SP8 for Win 2000 on this computer. This behavior seems
to be erratic, I was able to copy and paste the query with
a new name, the query runs once and then never again. I'm
inclined to think since other queries are running that it
may be linked to a corrupted record but compact and repair
does not seem to help. Does anyone have any suggestions
what I might do to track down this issue?
TIA
George
 
J

Jeff Boyce

George

What happens if you create a new query, from scratch? Try using a new name
for it as well.

If it works correctly and consistently, your "old" query is somehow
"munged" -- you could throw it away and rename the new one to the old name.

Have you made a backup copy of the database and then run Compact and Repair?
 
G

George Wilson

Been there, done that... It appears the query may be too
complex for Access to handle. The query is based on a
union all query, when the union all is removed the query
runs fine minus one essential field. Has anyone else had
issues with Access generating errors with a query based on
a union all query?
 
Top