Access Database Cannot Be Opened

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 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?

Overview About “The database cannot be opened because 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 needs 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 needs to be created from their source ACCDB, MDB, or ADP databases.

DON’T MISS IT:

Instant Fixes To Resolve Access database error -3049 “Cannot Open Database” Error…!

Access database created with 32 bit version of Access 2010 and are compiled as MDE, ACCDE, and ADE files works 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 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 to get opened because the VBA project contained in it can’t be read. 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 encounterance of this error:

  • Scenario 1:

When you create a complied access 2010 database MDE, ACCDE or ADE file on a computer which has 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 use the file on a PC, in which Access SP1 2010 (64-bit) is installed.

ALSO READ:

3 Instant Fixes To Resolve MS Access “the Database In An Unexpected State” Error

  • 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 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 latest version of VBE7.dll file (version 7.00.1619).

Resolution To Resolve “Access Database Cannot Be Opened Because The VBA Project Contained In It Cannot Be Read” Error

ERROR-29081

Solution 1::

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 version of Access 2010 which mainly targets to deploy MDE, ACCDE, or ADE file.

Solution 2::

Generally this error occurs when the version of 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 same version of access you will deploy the file on.

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

Notes:

  1. ACCBD file opens and execute perfectly in access development environment.
  2. ACCDE worked some point on 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.

YOU MAY ALSO LIKE:

How To Resolve “Access Form Not Updating Table” Issue In Access 2010/ 2013/2016 database?

Solution 3::

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

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

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

Recommended option:

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 lost data from access database whether it is lost due to corruption, any damage issue. It ensures safe and secure of your complete data items which includes.

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

Sum Up

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

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