Hi,

We have a pretty simple Access database which we need to secure.  We have 2
groups of people who need to access it; one group needs Full access and the
other group needs read only.  I know this can be done through the tools menu
but it all looks a bit complex, can anyone put it down in black and white for
me?

The 2 access groups will contain about 10 users each, so Ipresume we dont
have to set up 20 accounts, just 2 with different access levels?

Many thanks

kermitdafwog

You can assign permissions to groups and then when you create the user
accounts, you just put them in the appropriate group.

Do not just go to the Tools menu, and peck away.  You will not secure it
properly.  It's important to follow detailed steps, not missing anything.

If you are using 2003, the security wizard does a decent job.  The wizard
will create a backup of your unsecure mdb, should you not like the outcome.
You could always go back to the backup and start over.

It's a good idea to study up on security, and then practice on a copy of
your mdb.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm


Show quoteHide quote

kermitdafwog wrote:
39 printed pages in black and white:
http://support.microsoft.com/?id=207793  Study it and practice implementing
security a few times first on a practice version of your database, not the
real version.

How to add the security back to the normal database?
Multi users in one form
Use Level Security lockout
splitting the database and securing the back-end file?
Using User Level Security Wizard
Help with
RWOP and database permissions on backend
Can an Access database expire?
Can any one please explain me Access Security
Hex editor with word password