database shuts down when opening query in design mode

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.
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change/Save to aggregate query shuts down Access 6
It takes SO LONG TIME to open a query in design mode 3
Query will not open in Design Mode - Invalid use of Null 4
Can't create a report from my query in Access 1
Parameter Query Won't Run 0
Queries, see new fields when table design has changed 2
Access closes when saving query 1
Error on displaying query design 8

Top