protect a file

[JP Sanchez]

I designed a simple database for my pediatric practice. It
works fine, until I accidentaly erased one of my patients.
How can I protect these files against accidental removal,
but be able to erase them after a two step erase question
(ie: are you sure?) and also be able to open the file and
edit its contents.
thanks

 

[Larry Linson]

The Form event BeforeDeleteConfirm has a Cancel argument. If you set it to
True (you can insert "Are you Sure?" message and logic) before leaving that
procedure, it will cancel the Delete.

I do not know any way to prevent deleting from Datasheet View or via a
Query, except to deny those capabilities to the users.

Larry Linson
Microsoft Access MVP