Prevent Record Delete

  • Thread starter Thread starter PAFS
  • Start date Start date
How do I prevent users from deleting records?

Set the form's "AllowDeletions" property to "No".
 
How do I prevent users from deleting records?

Jim
Click to expand...

Implement Access Security on your database, and only give delete
rights to the superusers who can.

A partial solution would be to present users only with a Form to
interact with the data in the tables, and set the Form's AllowDeletes
property to False. This won't prevent a mildly knowledgable user from
going around the form to table datasheet view, however.
 
You must log in or register to reply here.

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 deletions of records from tables? 4
Deleting records on form 1
Prevent row from being deleted 2
Preventing Duplicate Records 7
How to do Simple Security? 4
child table showing #deleted 2
DELETE FROM a table WHERE... 1
restrict user from deleting a sheet 2

Back
Top