security

[Jackie]

I created a database in Access 2007 and need to move it to a common drive.
This information needs to be accessible for everyone who has the drive to
view the contents. How do I secure the database so that only 2 of us can
make changes or add to the database while everyone else can only view it?
Many thanks. Jackie

 

[Arvin Meyer [MVP]]

First of all you need to split the database so that only the data in the
tables is on the common drive. Failure to do that and sharing forms, etc.
will result in corruption After you have split the database, put a copy of
the front-end (everything nut the tables) linked to the data tables on the
common drive, on each user's workstation.

Now to get to your question: What you are asking for is User-Level Security.
The new ACCDB file format does not support that. If you are using that
format, convert it to an MDB to get that functionality: Here are some
articles to read to help you secure properly:

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
Co-author: "Access 2010 Solutions", published by Wiley