How to prevent users from deleting records?



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.

Douglas J. Steele

Don't let them have access to the tables, and set the Allow Deletions
property of the form to False (No)



Arvin Meyer [MVP]

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




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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question