Disable AutoSave In MS Access

[Diem Dang]

Hello,

Can someone please tell me if I can disable the Autosave
in MS Access? Currently, whatever I do to the Database,
MS Access would automatically save the new information
without confirmation. I would like to turn this
capability off and prompt users whenever they want to save.

Thank you in advance for your help.

V/r,

Diem

 

[Graham Mandeno]

Hi Diem

By "Autosave", do you mean the record being saved when you change focus to
another record? If so, then there is no built-in way to "turn it off".
However, it's easy enough to put some code in the form's BeforeUpdate event:

If MsgBox("Do you want to save changes?", vbYesNo) = vbNo Then
Cancel = True
Me.Undo
End If

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.