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]

Re: Sudden shut down when saving a Query

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

https://www.thedatabaseplace.net

"ITMA" <mindyourownbus iness@net.net> wrote in message
news:3fdb0f5d$1 _1@mk-nntp-1.news.uk.world online.com...[color=blue]
> 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?
>
>[/color]

[ITMA]

Re: Sudden shut down when saving a Query

> Sounds suspiciously like corruption. Make a new, blank database and import[color=blue]
> all your objects. Do this while you still can ... and I speak from
> experience[/color]

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.