Access 2007 FAQ
How do I apply User Level Security to my database in Access 2007?
In Access 2007, Microsoft removed the ability to apply User Level Security to databases in the new ACCDB file format. To maintain backwards compatibility, you can still apply and edit User Level Security for databases in the MDB file format.
To apply User Level Security to your database, you must first be working with or creating a database in the MDB file format. If you need help with creating a blank database in the MDB file format, please see the following page: Related Topic
When you are working with a MDB file format database in Access 2007, you'll see an additional group on the Database Tools tab called Administer, as shown in the screenshot below.
When you click the Users and Permissions button in the Administer group, you'll see the familiar three options for working with security in your database - User and Group Permissions, User and Group Accounts, and User-Level Security Wizard, as seen below.
If you need help understanding User Level Security, please see the following page: Related Topic
This Help article on Office Online might also be of assistance: Related Article
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page