Fix: The Database Cannot Be Opened Because The VBA Project Contained in It Cannot Be Read

If you compiled a Microsoft Access MDE, ACCDE, or ADE file and are trying to open it on another computer or in a different version of Access, you receive an 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. 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.

 

To create a backup copy, click Cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK.

 

This occurs when the version of Access you created the file in uses a different version of a VBE7 dll file and causes a compatibility issue. Compile your Access MDE, ACCDE, or ADE file using the same version of Access you will deploy the file on. As a workaround, you can update the target machine Access .dll file to the same version as the source machine. Finally, it is recommended to use VBE 7.1 to compile instead of 7.0.







* Please use the comment form below. Comments are moderated.*



Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Guest
Saturday, 04 February 2023