Database Security

[skiing]

For a network database and only that database - It would seem simply
to allow only a few users to be able to modify objects or enter data.
All other users would be read only. However, I can not seem to get the
settings correct. I have read, multiple times, the FAQ's on Security
which were offered as a reply to someone elses question. I have tried
to modify the Admin and User default groups and tried the Security
Wizard - neither seem to allow me and a co-worker to make changes but
also allow limit 50+ other users to view the data only (read only).
Can someone assist?

Facts:
one access database - stored on a network drive
multiple users have used it, entered data, added objects - in the
build phase
now -- need to protect months of data entry - but allow anyone else to
view the data.

Goal:
Full Admin Permission to 2 users
Read Only access to all other users.

 

[Arvin Meyer [MVP]]

You need to split your database and put a front-end on EACH user's
workstation, with only the linked data tables on the network server. Failure
to do that will eventually cause corruption of everything as 1 user drops or
ungracefully closes a connection.

Have a look at the security FAQ and these resources:

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