corrupted vba

[Ra]

Hi Everyone,

Something went wrong with this db, and I'm getting the "VBA file corrupted"
message, and "Id is not a valid index" when I attempt to open. I ran the
Compact and Repair menu w/out success. Are there any utilities out there that
I can use to attempt to repair this db?
Thank you in advance.

 

[Jerry Whittle]

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Marshall Barton]

Something went wrong with this db, and I'm getting the "VBA file corrupted"
message, and "Id is not a valid index" when I attempt to open. I ran the
Compact and Repair menu w/out success. Are there any utilities out there that
I can use to attempt to repair this db?

First make a copy of the mdb file so you can go back if your
attempts to fix things make it worse.

Access has a mostly undocumented feature that will discard
all(?) compiled code, which frequently is where the code
corruption is located.

Using Windows - Start - Run enter something like:

"C:\Program Files\Office 2003\Office11\MSACCESS.EXE" "full
path to mdb file" /DECOMPILE

If your compiled code really is the problem, the most likely
cause is editing code in an open form/report. Try to
develop the habit of **always** switching to design view
before typing anything in a form/report code module.