No of visitors who read this post: 406
Category: Misc Databases
Type: Question
No votes yet

I’ve created a Microsoft Access 2007 database (.accde, or .mde or .ade) with a view to providing some other users. The program runs well on my own machine and some other user’s machines. But some people have complained that they get the following error message while trying to run it.

The message says that the VBA project is corrupt though the same program runs on other machines properly. This is an .accde or .mde or .ade format file and they can’t open it. I don’t understand how it can be corrupted. I need a solution to this problem. I’ll be grateful if you can provide me with a solution to this problem, please.

Error:

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# Comment Id: 57433

The reasons/causes why it corrupts are improper system shutdown, virus infection, application crash and many more. 

In this case, you need to recreate the database . 

If you are editing a database over a network, don't do it on your local computer it's ok to do it over LAN.  

If backup is not available or incomplete, you can use the third party Access file repair software.

It will help you repair and restore database.

Stellar's Access Recovery software is designed to repair damaged/corrupted MS access database (.mdb or .accdb) it creates new useful database to restore all database objects without changes from it's original.

It uses high application scanning technique. follow this link

# Comment Id: 57438

In this case, first thing to do is to have a back-up of your data. To do this, you can re-open your database and access through MSQuery in Excel or open new blank .mdb and import all the data from the old .mdb. And Try pressing and holding down the shift key when you open the DB.

To troubleshoot, Start by opening the VBA editor, go to the Tools menu and choose References. But if you have the multiple version of access installed in your computer. Then you need to have latest and update version of your Microsoft Access.