Adding users to MS Access Database for security

Question

I need to share the database on a shared drive and hence want to restrict the users from being able to access the database. Can I add users and limit their ability to view/edit/update? Read many articles but cannot locate the security option on the toolbar to add work groups.

Answer 1

Thank you. Will check.

Answer 2

In addition to the Active Directory option you will also find an article on the blog about using VBA to control security.

Answer 3

You can only implement user and group security if the file is in .mdb format, in which case you'll find the relevant icon on the Database Tools menu.  For the use of Active Directory to implement security with .accdb files see the blog by Tom Stiphout et al at:

http://www.accesssecurityblog.com

If you do wish to implement user and group security for a file in .mdb format you should download and study very carefully the FAQ document on the subject from:

http://support.microsoft.com/kb/207793