Saving Query Closes Access

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.

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

"Martin" wrote in message
...
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.

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

"Martin" wrote in
message
...
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.


.