Multi-Access Issue

[Ayo]

How do I set up an access database file such that there is a password to
enter and edit the file, and no password to enter and just use the file to
gather information.

The situation is that only one person will be entering data into the file,
she needs the password, everyone else just want to be able to go in there and
look around and see what the data is.

Any help will be greatly appreciated. Thank you.

 

[Arvin Meyer [MVP]]

If you use the mdb format, you can set up user level security. It is quite
involved, so you'll want to read the following:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

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

You can also build your own security, although it may take longer if you
have lots of objects to secure. First find out who the user is:

http://www.mvps.org/access/api/api0008.htm

The based on the user, change the editing on the form in code:

Sub Form_Open(Cancel As Integer)
If UserName() = "Arvin" Then
Me.AllowEdits = True
Me.AllowDeletions = True
' ... etc.
Else
Me.AllowEdits = False
' ... etc.

 

[Ayo]

Thanks Arvin. Thess should be very helpful.

If you use the mdb format, you can set up user level security. It is quite
involved, so you'll want to read the following:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

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

You can also build your own security, although it may take longer if you
have lots of objects to secure. First find out who the user is:

http://www.mvps.org/access/api/api0008.htm

The based on the user, change the editing on the form in code:

Sub Form_Open(Cancel As Integer)
If UserName() = "Arvin" Then
Me.AllowEdits = True
Me.AllowDeletions = True
' ... etc.
Else
Me.AllowEdits = False
' ... etc.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com