Instructions / Advice About Security Setup

[greaseman]

Does anyone know if there is a site or a thread that provides simpler instructions for setting up and using security on an Access application? I've read Microsoft's items, but can't really decipher them! I think my problem is conceptual on my part. I've set up a test mdw, and set up user / group permissions in the mdw, but just can't grasp some of the concepts.

My confusion is as follows: I want obviously to keep users out of the tables, queries, code, etc., but if I set up Ralph as read-only in my data tables, how do I set up Ralph so that he can use a form to add/delete/edit into that same table?

What I want to do is keep folks away from back-dooring into things, but at the same time provide them the means to "nicely" get into their data and functions.

I've looked through this forum but haven't found postings regarding this thought, so if anyone can just point me to simpler explanations or examples, it would really make my day.

Thanks a million!

 

[ghudson]

The users should never be allowed access to open a table or the design view of any db object. They should only be allowed to access the data through a form. You need to hide/disable everything else if you are not able to distribute the runtime version of Access for your application.

Visit this site... http://www.jmhare.com/dbsecurity.htm

 

[greaseman]

Thank you for your reply.... I had discovered the like you suggested quite a while ago, but then managed to lose it. I appreciate the info and am glad to get that link back!

 

[The_Doc_Man]

As to this site's threads, over the last two years or so, Pat Hartman and I have replied to MANY questions about setting up Workgroup security. Also, I think Vassago has replied a lot, and many others have added their advice. Search this forum for topics "Workgroup Security" and find the threads where Pat or I expounded on security setups.

 

[greaseman]

And, thanks for your response. I was actually looking for information such as resides at the site that ghudson was so kind to provide. I had searched and looked through the forum for several hours using terms like "security", "workgroup security", "workgroups", "levels of authority" and the like, but remained almost as confused as before starting my search.

I had only been hoping there might be something "out there..." a bit more understandable related to the steps of instituting security.... I had read Microsofts items about security, and had done a bit of searching and researching prior to posting my plight and plea.

Again, thanks..... I'll keep looking.