Confused with security set up



I have a database that I want to set up security on as follows:
Group 1 = Admins will have full access with the ability to make changes, etc.
Group 2 = Users who will have read only access to all objects in the database

I want to assign passwords to each group and just give out the passwords to
the people assigned to their respective group. I do not want to assign/list
each individual to a group in my database if there is a way to avoid it.

Is there a way to do this and if so, please point me in the right direction
for step-by-step instructions.

Thank you!

Daniel Pineault

What version of access are you working with?

If it is 2003 or prior then you can use the USER-LEVEL SECURITY feature to
set everything up in a few minutes.

However, it is 2007 or 2010 then you're out of luck. MS in their infinite
wisdom removed this feature so you'd have to create your own security
measure, login form.... Not hard, but still not for the faint of heart to do
properly. Search a little on Google and you can find examples to get you off
to a good start.
Hope this helps,

Daniel Pineault
For Access Tips and Examples:
Please rate this post using the vote buttons if it was helpful.


I am using 2003. I have searched on Google and am not understanding the
instructions that I found. I actually found two different sites that gave me
step by step instructions showing how to create groups and add users. I just
want the two users groups with different passwords for each to simplify the
process for everyone.

I will play with it more but would appreciate some help to get me going in
the right direction.

Thanks for you reply.

Stewart Berman

It is impossible to secure the contents of an Access accdb or accde file
against a user that can open it. It is trivial to turn the use of the
bypass key back on and make the ribbon and navigation pane completely
visible giving full read/write access to all tables, macros and queries.

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