VBA corruption

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have an Access 2002 application that is presenting the
following error message: "The Visual Basic for
Applications project in the database is corrupt." This
happens when I try to open any object. I have tried
unsuccessfully to compact and repair, and I cannot import
anything into a new clean file. I have read the decompile
suggestions, but that doesn't seem to work either, unless
I am not issuing the decompile command properly. Is there
any hope for this situation?
Thanks in advance...
Ron
 
I recently have an issue where I could not work with a
database file due to a VBA problem. The decompile worked
for me. The way to use it is to create a shortcut with
the path to your MSACCESS.exe file then the file you are
wanting to decompile. Here is the string that I put in my
shortcut:

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "C:\Full Path to your db
file\YourFileName.mdb" /decompile

HTH

Byron
 
Ron, this message occurs even if you create a new database, and then open a
code window and try to create a new module? If so, your installation of
Access must have been messed up, probably by installing something else. Try
uninstalling Office 2002, and installing from scratch.
 
Byron and Allen,
THanks for the info. The first file I tried to decompile
wouldn't work, but I had another (earlier)copy, which I
had begun rebuilding with the functionality in the
corrupted one. It too become corrupted and this time the
decompile worked fine and I was able to continue. Thanks
again for your help.
Ron
 
Back
Top