Secure a database by using the User-Level Security Wizard

With the User-Level Security Wizard, you can apply user-level security with a comprehensive security scheme and encrypt your Microsoft Access database.

1. Open the database that you want to secure.
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 secures the selected objects in the current database.
• If your current Access database protects Microsoft Visual Basic for Applications (VBA) 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 file.