Show All

Hide All

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

With the User-Level Security Wizard, you can apply user-level security (user-level security: When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.) with a comprehensive security scheme and encode your Microsoft Access database (database: A collection of data related to a particular subject or purpose. Within a database, information about a particular entity, such as an employee or order, is categorized into tables, records, and fields.).

If the wizard doesn't start

1. Open the database that you want to help protect.
2. On the Tools menu, click Security, and then click User-Level Security Wizard.
3. Follow the directions in the wizard dialog boxes.

Notes

• The User-Level Security Wizard creates a back-up copy of the current Access database with the same name and a .bak extension, and then employs security measures for the selected objects in the current database.
• If your current Access database helps protect Microsoft Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Windows applications and is included with several Microsoft applications.) code with a password, the wizard prompts you for the password, which you must enter or the wizard doesn't complete successfully.
• Any passwords that you create through the wizard are printed in the User-Level Security Wizard report when you finish using the wizard. You should keep this report in a secure location. You can use this report to re-create your workgroup (workgroup: A group of users in a multiuser environment who share data and the same workgroup information file.) file.