Access automatically closing

[Cindyb]

Why would Access automatically close the database when you
a trying to open a particular query in design view?

Thanks

 

[Allen Browne]

Probably another one of the Name AutoCorrect bugs. See:
Access Quits Unexpectedly When You Run a Query
at:
http://support.microsoft.com/?id=322794

For other reasons why you want to turn this feature off, see:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning it off, compact the database:
Tools | Database Utilities

You may also want to decompile a copy of the database by entering something
like this at the command prompt while Access is not running. It is all one
line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

If the problem remains, then tell us more about this query - particularly
whether it contains subqueries and stacked queries.