How do I limit users from deleting records from tables

S

supemsd

I have trouble with the user and group accounts in securing a database. I
generally wind up locking myself out of the database. The task at hand is to
limit the majority of users from deleting records from tables located in a
specific database. How do I use the wizard or whatever to assign
permissions. Must I render the database exclusive before I begin? We have
machine names and user names and passwords in our windows management system.
Do I define users by machine name or their user name? Seems a little tricky
to me. Perhaps you can refer me to an article or something.

Thank you,

Mike Dryer
 
T

TC

Try the "Access Security FAQ", often referenced in this newsgroup.
(Sorry, I don't have the url to hand, a quick google search should find
it).

If your users can only access the tables via forms - as should normally
be the case - perhaps you can just set the form level AllowDeletions
properties to False - then no users (regardless of security level) can
delete records via those forms.

HTH,
TC
 

Hi,
I hope it isn't inappropriate to reference a Security Guide that I found
useful. The guide was mentioned on the microsoft discussion group as
available at http://geocities.com/jacksonmacd/. It provides step-by-step
instructions and it worked great for me! At first it was a mind bend and I
didn't want to follow it but now I would like to thank the creator of the
document. I encourage you to look it up and do what it says.
@eroD
 

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