Sudden shut down when saving a Query

[ITMA]

When I go to close a Query to which I have made changes, I get prompted to
save it, I say yes, and then Access suddenly closes itself down and when I
reopen the database the Query has not been saved at all. Anyone know what
these two inter-related faults are all about?

[Scott McDaniel]

Sounds suspiciously like corruption. Make a new, blank database and import
all your objects. Do this while you still can ... and I speak from
experience <grin>.

--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

"ITMA" <mi*****************@net.net> wrote in message
news:3f**********@mk-nntp-1.news.uk.worldonline.com...

When I go to close a Query to which I have made changes, I get prompted to
save it, I say yes, and then Access suddenly closes itself down and when I
reopen the database the Query has not been saved at all. Anyone know what
these two inter-related faults are all about?

[ITMA]

> Sounds suspiciously like corruption. Make a new, blank database and import

all your objects. Do this while you still can ... and I speak from
experience

Tried that, and it did the same thing. Incidentally, Access seems very
prone to corruption in my experience, almost to the point that the risk of
losing data / general design work make it worth not bothering with in the
first place.