Help with security setup

[Yappy]

I have an Access 2000 database that I need to set up security as follows:

Users = Restricted & Non-Restricted

Restricted users get read only permission; non-restricted get full access

How can I set these up so that I do not need to add individuals' names to
each?

I want them to be able to open the database and type in a password which
will identify the type of user they are and open the correct version.

I have been trying the different methods that I have researched on the
internet but am not completely understanding the steps involved.

I only want to set up security for one database; not all databases that I
create.

Any help would be appreciated.

Thanks!

 

[Arvin Meyer [MVP]]

Here is the best available security advice:

Security FAQ
http://support.microsoft.com/support/access/content/secfaq.asp

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

 

[Yappy]

Thank you for all the links.

Here is the best available security advice:

Security FAQ
http://support.microsoft.com/support/access/content/secfaq.asp

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access





.