Fix: Access 2010 SP1 Wizard Error | "The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted"
Real quick one today, one of my users today told me she had been holding off upgrading to Office 2010 SP1 due to an error using one of the Wizards in Access 2010.
She happened to be on x64 but I believe this was a bug in both.
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."
Once you click OK on this message, you may receive any of the errors below:
Cannot update. Database or object is read-only.
The Visual Basic for Applications project in the database is corrupt.
Microsoft Access can’t find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this wizard has been disabled.
Well all you need to do to fix it is get the hotfix from Microsoft:
Just simply scroll down to the large consumer focused icon that say "Microsoft Fix It" and click it. You download a quick package which patches Access.
Note: Make sure you close down all of Office first!