Securing Access database

[Guest]

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

 

[Joan Wild]

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

 

[Granny Spitz via AccessMonster.com]

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?

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.