VBA project contained in it cannot be read

[Nro]

Hi all. Access 2007 – Windows XP Professional / Windows 7 Ultimate

We develop a totally new database in Access 2007. Everything works fine, until now. If the user tries to run one form or access any code, he receives this message:

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

Of course, if he press yes, Access removes all the code from all the modules, forms and reports. It fixes the problem, but, you know, now the application is not working (I wonder why…)

Now, here what I tried :

Open the database exclusively
Open it locally
Open the database with Access 2010
Try to import any objects (from 2007 or 2010)
Try to compact it

Nothing works. I know that I can use one backup and put it back in production, but I still want to correct this corruption.

Any idea ?

Thanks

Nro

 

[PHV]

Do a google search for msaccess decompile

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Nro]

Thanks PHV

I did a search and /decompile does not work for me.

I think this code was not even compiled before the corruption.

I torture my user a little bit more, and he finally told me that before the corruption he was working on the system via a VPN. He then got a "Critical error" and the VPN crash, the database got corrupted.

Thanks

Nro

 

[MajP]

http://support.microsoft.com/kb/295334

you tried most of the usual suspects. Not sure if this will support 2007, but have you tried jetcomp? Sometimes it is able to fix others that will not compact/repaire.