The visual basic is corrupt

Asked By jeffrey montes 10 points N/A Posted on - 05/08/2012

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.

• Status: Open
• Question Views: 1287
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Databases

Best Answer by benchz24

Go To Solution

Answered By Pascarella Fernax 20 points N/A #103149

The visual basic is corrupt

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: 

 

About Pascarella Fernax

Questions
5

Answers
131

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 05/08/2012
• Question Category: Misc Databases

Best Answer

Best Answer

Answered By benchz24 0 points N/A #103150

The visual basic is corrupt

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. 

 

About benchz24

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 05/08/2012
• Question Category: Misc Databases