How to prevent users from deleting records?

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

Access 2007

I have created a database for users to create records (ex: call requests).
How to I protect these records so the users can't go back and accidentally or
maliciously delete them once they've been added.
 
Don't let them have access to the tables, and set the Allow Deletions
property of the form to False (No)
 
In addition, you might let them think they are deleting records, by giving
them a Delete Button that marks the records as not visible.

Ad a Boolean (yes/no) field to your table. Change the recordsource of your
forms and reports to only show records not marked

The code in the delete button should read something like:

Me.chkNotVisible = True
DoCmd.Requery
 
If you are using the MDB format, remove the Delete Data
permission for the table, to prevent users accidentally
deleting records.

You don't have to set up user level security to do this.

If you do want to delete a record, you can just add the
Delete Data permission back, delete the data, then remove
the permission again.

(david)
..
 
Back
Top