Access generates errors trying to run/design a query

  • Thread starter Thread starter George Wilson
  • Start date Start date
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
 
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?
 
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?
 
Back
Top