Corruption Repair Proigram

[gg80]

Using Access 2007 with most programs created with Access 2003. Recently, I had some awful on-line help while fixing a computer problem that just wiped out all my programs. I was able to reload the ones I still had discs for. One thing I miss horribly is the Access corruption repair program. With it, I could just go to the icon, enter the location & name of the problem program, click go, and program would be fixed! I believe that I got it from someone on this site a long time ago. Having trouble finding it on the web-lots of variations and not sure what they do. I would much appreciate someone telling me how to get the fixer program back on my computer.

[ranman256]

does the Access built-in repair not work?

[isladogs]

As Ranman suggests, try the built in fixes first
1. Compact and repair will shrink the database to remove unused space and may do some minor repairs.
2. Decompile -removes any corrupt compile code and in my experience fixes the vast majority if issues
See http://www.fmsinc.com/MicrosoftAcces.../Decompile.asp
3. After decompiling you should compile from the Debug menu in the VBE to fix any errors in your code
Before doing so, tick require variable declarations in the VBE Options
This will add the line Option Explicit to all new code modules but it won't act retrospectively
So go through each code module and add Option Explicit as the second line after Option Compare Database

Then click Debug...Compile fixing each error it finds in turn
You may have to do this several times to fix all errors

Finally compact your db.

IMPORTANT
Before doing any of this, make a BACKUP copy of your db, just in case.
Once fixed, you can delete the original backup.
However, suggest you then backup the fixed db.

[gg80]

i was just checking other things and realized that I haven't thanked you two for the help. Thanks again.

[isladogs]

On behalf of both of us, you are very welcome.
Did the advice help you to solve your issues?

[gg80]

Yes it did. Of course, I got a bunch more trying to use Access to work with excel xlsm files. I can't understand why msoft changed Excel the way they did. They didn't make it better.