Share via

Secure a database using the User-Level Security Wizard

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

By using the User-Level Security Wizard, you can apply user-level security with a commonly-used 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 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 though 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 also use this report to re-create your workgroup file.