Can I turn off auto save?

  • Thread starter Thread starter Evan
  • Start date Start date
E

Evan

I have a database with about 3000 records and many fields
in each record. My problem is that often times users will
accidentally make changes on a record, and the database
automatically saves all changes made. Is there any way to
allow users the option of saving any changes they made or
not when they close Access?
 
I have a database with about 3000 records and many fields
in each record. My problem is that often times users will
accidentally make changes on a record, and the database
automatically saves all changes made. Is there any way to
allow users the option of saving any changes they made or
not when they close Access?
Click to expand...

You will need to ensure that the ONLY way users can interact with the
data is via a Form. Table datasheets don't have any usable events!

On a Form, you can put VBA code in its BeforeUpdate event, and cancel
the update unless you determine that the changes are allowed - or, if
the users should never make changes at all, just set the AllowEdits
property of the form to False.
 
Hi Evan,

Perhaps the simplest thing to do is to set each form's AllowEdits
property to False. You must also make sure the users always use forms,
and cannot access the actual table datasheets - which is good practice
anyway.

If you want to allow non-accidental edits, one way is to put a
ToggleButton on the control with code behind it to set or clear
AllowEdits.
 
Back
Top