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)
..
 

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

Similar Threads

Prevent user from copy record 1
Allowing User Permissions to a Control 7
Password protect a form record? 1
Access User Login form in Access with Ristriction 0
Record insert/delete anomaly 0
Access 2007 can't save record 1
Game-guide apps delivered malware to 2 million Android users 0
Problem deleting records - Access XP and our intranet 4

Back
Top