Delete data permission

B

Brian

Maybe dumb question, but if I set security so that users cannot delete data,
is that at the manual level in tables or will it prevent them from using a
command button on a form that deletes records? I want them to be able to
delete from there only.
 
C

Chris O'C via AccessMonster.com

Not a dumb question. It's a good one. If you remove delete data permission
on a table for a user, that user won't be able to delete data from that table
no matter which way he tries, not in the table, not in a query, not in a form,
not by code or a macro.

So how do you only allow the user to delete records using a form? Another
good question. Remove all permissions to the tables from all users except
from the Admins group and any special group you want to have certain data
permissions. As a member of the Admins group (which has permissions to the
tables) write a select query that shows the data in the table and give it
"run with owner's permissions" (RWOP) and base the form on that query. Then
give the users permission to open/run the form. When the user opens the form
and pushes the button to delete the record, it works (because you as the
owner have permission to delete the record). If the user tries to open the
table to delete records, he can't because he doesn't have any permissions on
that table.

Chris
Microsoft MVP
 

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

Top