Saving Query Closes Access

[Martin]

I have made a small change to a complex query. The query
runs ok. However, when I try to save it, MS Access just
shuts down. The query is not saved.
The query used to run and save ok before the change. Now,
even if I remove the changes, it will not save any more.

I run Windows 2000 and Access 2000.

 

[Ken Snell]

Hmmm... sounds like a problem that I recently had in a database. And if the
cause is the same as mine, here is the fix:

Go to Tools | Options and click on the General tab, and deselect the "Track
name AutoCorrect info" option.

Surprisingly, the AutoCorrect option is the source of many weird happenings
in ACCESS, and it's one of the first things to turn off when you see weird
behavior.

 

[Martin]

Thanks for the help.
Very strange, but it works.

-----Original Message-----
Hmmm... sounds like a problem that I recently had in a database. And if the
cause is the same as mine, here is the fix:

Go to Tools | Options and click on the General tab, and deselect the "Track
name AutoCorrect info" option.

Surprisingly, the AutoCorrect option is the source of many weird happenings
in ACCESS, and it's one of the first things to turn off when you see weird
behavior.

--

Ken Snell
<MS ACCESS MVP>




.