How To Fix “Access Database Cannot Be Opened Because The Vba Project Contained In It Cannot Be Read” Error?

fix Access Database Cannot Be Opened error

Encountering error message “The database cannot be opened because the VBA project contained in it cannot be read” at the time of compiling the Microsoft Access ACCDE, MDE, or ADE file or trying to open these Access database files on another PC or different version of Access?

Looking for the fixes to resolve this specific Access Database Cannot Be Opened Because The Vba Project Contained In It Cannot Be Read error code?

Don’t worry because you are at the right location, as this blog mainly targets to resolve this “Access database cannot be opened because the VBA project contained in it cannot be read” error?

Fix Microsoft Access Issues
Run a database Scan with Stellar Access Database Repair Tool to repair inconsistent Access database. After the scan is complete, the repair process will restore the database to its normal state fixing all the errors.

By clicking the button above and installing Stellar Repair for Access (14.8 MB, $79 USD), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

Overview About “The database cannot be opened because of the VBA project ….” Error :

Microsoft Access databases which are made using the 64-bit version of Microsoft Access 2010 and complied as MDE, ACCDE, and ADE files need to be recompiled in Microsoft Access 2010 Service Pack 1 (SP1) to work correctly with Access 2010 SP1.

Access 2010 MDE, ACCDE, and ADE database file which are built using the initial database, version of 64-bit Access 2010 or RTM are incompatible with SP1. Access 2010 databases MDE, ACCDE, and ADE that were compiled in Access 2010 SP1 won’t work flawlessly with the RTM version.

The complied Access MDE, ACCDE, and ADE databases need to be created from their source ACCDB, MDB, or ADP databases.

Access database created with a 32-bit version of Access 2010 and are compiled as MDE, ACCDE, and ADE files work correctly with Microsoft Access 2010 SP1.

However Access MDE, ADE, AND ACCDE databases which are created by using 32-bit version MS Access 2010 SP1  won’t work smoothly with the RTM version.

Practical Scenario:

Hey Gang

I am trying to create a .accde file to use on another computer which I have installed Access Runtime. However every time I try to open the file I get the following 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.”

Can anyone suggest a solution?

Kind Regards
Jason

Source:

http://www.utteraccess.com/forum/Database-Opened-VBA-t1986300.html

Error Details:

“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.

OR

The Visual Basic for Applications project in the database is corrupt.

OR

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.

Error Number:    Error 29081

Error Description:

Database denies getting opened because the VBA project contained in it can’t be read. The database only gets opened when the VBA project is deleted first. Deleting up the VBA projects will delete all code from modules, reports, and forms. So it’s better to take proper backup of your VBA projects before stepping to delete it.

Symptoms Of Access Database Error 29081:

Here are the following scenarios of encountering of Access Database Cannot Be Opened error:

  • Scenario 1:

When you create a complied access 2010 database MDE, ACCDE, or ADE file on a computer that has a release version of Access 2010 (64 bit) is installed.

  • Scenario 2:

Create a complied access 2010 MDE, ACCDE OR ADE file on which the release version of access 2010 (64-bit) is installed. After then using the file on a PC, in which Access SP1 2010 (64-bit) is installed.

  • Scenario 3:

You must have complied Access 2010 MDE, ACCDE, or ADE file on PC in which Access 2010 SP1 (32-bit) is installed. After then try to use the file on PC in which release version of Access 2010 (32-bit) is installed.

In the following aforementioned scenarios, when you run the VBA code you will encounter the following error message:

“The database cannot be opened because the VBA project contained in it cannot be read. “

Causes Of Access Database Error 29081:

This specific Access Database Error 29081 occurs because Access 2010 SP1 uses the latest version of VBE7.dll file (version 7.00.1619).

Fixes For “Access Database Cannot Be Opened Because The VBA Project Contained In It Cannot Be Read” Error

ERROR-29081

Solution 1: Compile Your MS Access application 

In order to fix Access database cannot be opened because the VBA project contained in it cannot be read error. Compile your Access 2010 MDE, ACCDE, or ADE file using a version of Access 2010 that mainly targets to deploy MDE, ACCDE, or ADE file.

Compile the MS Access application with a version that is higher than the one which is used by the user trying to open the ACCDE file.

It is quite simple as compiling with MS Office 14.0.7151.5001 and users receiving the error is running 14.0.4760.1000. Once the user is updated to 14.0.7151.5001 then the application used in this starts to work again.

For more information: https://support.microsoft.com/en-us/kb/2533794

Solution 2: Resolve The Compatibility Issue

Generally, this error occurs when the version of the Access database file created by you, uses a different version of VBE7 dll file. This generates a compatibility issue.

Compile access MDE, ADE, or ACCDE file using the same version of access you will deploy the file on.

To fix this up, update the target machine Access .dll file to the same version as the source machine. It’s recommended to use VBE 7.1 to compile instead of 7.0.

Notes:

  1. ACCDB file opens and executes perfectly in the access development environment.
  2. ACCDE worked at some point on the user’s machine that currently not working.
  3. Some previous versions don’t work either.
  4. You can also try decompiling, compact and repair and starting new DB and copying objects in.

Recommended Option To Fix Access Database Cannot Be Opened Issue:

Meanwhile, performing the manual fixes or due to any other issue if any data loss situation arises then give it a try to Access Database Repair And Recovery solution. This is an ultimate solution to retrieve any of the lost data from the access database whether it is lost due to corruption, any damage issue. It ensures the safety and security of your complete Access database items.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB, $79 USD), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

This Access recovery software fix corrupted or damaged MS Access (ACCDB and MDB) files and save the repaired file to their default or a user-specified location.

Steps To Use MS Access Repair and Recovery Tool

Sum Up:

Hopefully, the aforementioned helpful tips and solutions assist you in understanding MS Access error 29081. And take appropriate measures to avoid or fix if needed. To be on the safe side, always maintain a proper backup of your crucial database files.

tip Still having issues? Fix them with Stellar Repair for Access:

This software ensures seamless repair & recovery of ACCDB & MDB database and restores all objects including tables, reports, queries, records, forms, and indexes along with modules, macros, etc. Fix Microsoft Access issues now in 3 easy steps:

  1. Download Stellar Access Database Repair Tool rated Great on Cnet.
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Avatar

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.