Fix Microsoft Access Form Import Errors Caused by VBA Passwords
Question details
Users are unable to import forms or databases from a backup due to password protection.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Importing a form or a complete database from a backup file into a new or existing Access database.
- Observed behavior
- The import process fails because the VBA project is still password-protected, even after the main database password has been removed.
Ensure you have the correct authorization and the actual password for the VBA project, as it is completely separate from the main Access database password.
Remove the VBA Project Password and Retry Import
Clear the VBA project password from the source database to allow unrestricted importing of forms and modules.
A common misconception is that removing the Access database password also unlocks the Visual Basic for Applications (VBA) code. Microsoft Access handles these two security layers independently. To fix the import error, you must explicitly disable the VBA project protection.
Launch Microsoft Access and open the original database file that contains the form or backup you are trying to import.
Press Alt + F11 on your keyboard to open the Visual Basic for Applications (VBA) editor.
In the Project Explorer pane on the left, click on the VBA project. You will be prompted to enter the VBA password. Type the password and click OK.
Go to the top menu and select Tools, then click on [Your Project Name] Properties. Navigate to the Protection tab.
Uncheck the 'Lock project for viewing' box. Delete the asterisks in both the 'Password' and 'Confirm password' fields, then click OK.
Save your database, close Microsoft Access completely, and then restart the application to retry importing your form.
Discover WPS Office for Your Daily Productivity Needs
While Microsoft Access handles complex relational database management, WPS Office provides a robust, lightweight suite for your everyday document, spreadsheet, and presentation tasks. It offers seamless compatibility with Microsoft Office formats, saving you money without sacrificing functionality.
Frequently Asked Questions
Why does Access say my database is protected even after I removed the database password?
Microsoft Access applies separate security measures for the database file itself and its internal VBA code. You must remove the VBA project password separately in the VBA Editor via Tools > Properties.
Can I import an Access form without its underlying VBA code to bypass the password?
Generally, Access attempts to import the form and its associated class modules together. If the VBA project is locked, the entire import process for that form will be blocked to protect the intellectual property of the code.
How do I access the VBA Editor in Microsoft Access?
You can quickly open the VBA Editor at any time by pressing the Alt + F11 keys on your keyboard while your Access database is open.
