Secure a database using the User-Level Security Wizard

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.