database shuts down when opening query in design mode

  • Thread starter Thread starter geode_1
  • Start date Start date
G

geode_1

When I try to open a query in design mode, access shuts
down. No error message appears. I can run this same query
without error. However, once I save and try to reopen, the
system crashes.
 
This sounds like corruption. You might try grab the sql by pressing Ctrl+G
and entering:
? CurrentDb.QueryDefs("YourQueryName").sql
press enter.
You can then take the result and paste it into the sql view of a new query.
After testing, delete or rename to old query and the new query.
 
Back
Top