Saving when I don't want to

[Marc]

Hi,
I'm in Access 2000 on Windows 98. Occasionally, especially
when I've been creating and modifying forms, Access will
start saving anything I close automatically, without
asking if I want to save.

When I close Access and reopen, this doesn't happen
anymore.
Is this a bug in Access? I know it's really just an
annoyance, but is there a fix?

Thanks,

Marc

 

[Tony Toews]

Hi,
I'm in Access 2000 on Windows 98. Occasionally, especially
when I've been creating and modifying forms, Access will
start saving anything I close automatically, without
asking if I want to save.

When I close Access and reopen, this doesn't happen
anymore.

You have a docmd.setwarnings false without the correspending
docmd.setwarnings true.

If you're going to use docmd.setwarnings make very sure you put the
True statement in any error handling code as well. Otherwise wierd
things may happen later on especially while you are working on the
app. For example you will no longer get the "Do you wish to save your
changes" message if you close an object. This may mean that unwanted
changes, deletions or additions will be saved to your MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Marc]

-----Original Message-----


You have a docmd.setwarnings false without the correspending
docmd.setwarnings true.

If you're going to use docmd.setwarnings make very sure you put the
True statement in any error handling code as well. Otherwise wierd
things may happen later on especially while you are working on the
app. For example you will no longer get the "Do you wish to save your
changes" message if you close an object. This may mean that unwanted
changes, deletions or additions will be saved to your MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
.
Thanks Tony,

Marc