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

Lynn Trapp's summarization:

KB articles:;en-us;q165009

Joan Wild's articles:
Arvin Meyer, MCP, MVP
Co-author: "Access 2010 Solutions", published by Wiley

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

security not for security 3
Secured database is not secure 3
Security 2
Security 1
Security 0
Security 0
Security 0
Security 1