Security

[GOL]

I have built a database for my company...works great, just need good
user-level security. Where can I find some easy to follow and thorough
literature on how to set up this security? The database is located on our
company intranet, don't know if that makes matters worse. I need security
where everyone can view the info, but not edit or add any. I will then have
a few amount of logons that can alter and add data. Question-can more than
one person log under the same name? This would make it easy having just two
logons-one that doesn't need a password or logon (universal user) for
read-only, and one that gives access to editing and adding data that these
few people could use simultaneously. Any help or references is appreciated.

 

[Rick B]

Check out the following links...



Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

I have built a database for my company...works great, just need good
user-level security. Where can I find some easy to follow and thorough
literature on how to set up this security? The database is located on our
company intranet, don't know if that makes matters worse. I need security
where everyone can view the info, but not edit or add any. I will then have
a few amount of logons that can alter and add data. Question-can more than
one person log under the same name? This would make it easy having just two
logons-one that doesn't need a password or logon (universal user) for
read-only, and one that gives access to editing and adding data that these
few people could use simultaneously. Any help or references is

appreciated.