DataBase - How to make Access 2003 ask for confirmation before saving change.

Asked By John Max

18-Nov-09 10:17 AM

My Access 2003 program does not ask for confirmation before saving changes.
How do I change that?

18-Nov-09 03:15 PM

The usual way is for Access to ask you to save if you are making design
changes to forms, queries, tables etc.
Are you not getting the save prompt when you make design changes?



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

09-Dec-09 10:35 AM

I am having a similar problem.  I have two Access 2000 format databases that
I have made copies of to work on.  I am using Access 2003 sp3.  Whenever I
close a form or query the changes are saved without asking unless it is a new
form or query then it asks for the form or query name.  I am not allowed to
exit without saving.  I have opened a new database in 2000 format and
imported forms, tables, and queries and that instance behaves normally.  I
have compared all of the settings in options and all of the items in database
properties and they are the same.  While I can work with this, it is very
annoying and has also captured some unintended changes when modifying thing
to diagnose problems.  Any insight would be helpful.

09-Dec-09 02:24 PM

As this has never happened to my databases - it is hard to know where to
start for this problem.
Does A2003 have the service pack SP3?
When the tables, queries and forms etc are imported into A2003, do you have
it set to A2000 - A2003 format, or do you have A2002-A2003 format?

Try this-->
Create a new database in A2003 and put just one table in it.
Make another design change to that table and see if you are asked to save
changes.

Now import just one table from your A2000 format database and try a similar
thing.

What do you find?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

09-Dec-09 03:17 PM

The most likely culprit for this behavior is the Name auto correct property
in A2003.
Try this.
Go to Tools | Options | General Tab | Name Auto Correct

Turn off name auto correct, backup the database then do a compact and
repair.
Let us know if this fixes the problem.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia