Corrupt DB

[spowers21]

I hope that someone can help me. I have scanned this forum and the internet without any luck. I have an MS Access db that I have been working on for several months and yesterday, somehow or another, it became corrupt. The biggest problem I have is I do not have a good backup to restore from. When I open the db I get the "Your database is corrupted ....." message and it will not allow me to compact or repair nor can I create a new db and import the objects. All of my tables are linked to a back-end so I have not lost any data. I can see all of my objects and I can also get into the design of each. However, I cannot get into any of my modules or any design of a form or report that may have some VBA in it. I am not sure that I can recreate all of the VBA that I stand to lose, so any help would be appreciated. Thanks.

 

[ted.martin]

There is propretary software around but you may have to buy it. Search Google using "restore corrupt access database". Good luck - just proves the value of regular back-ups.

 

[spowers21]

Yea, I am learning my lesson on backups. I usually do, but for some dumb reason this time I didn't. I have an enormous amount of time tied up with this db and I am not sure that I can re-created all of the modules ( it's a brain capacity problem). I'll keep looking, thanks for your reply.

 

[allan57]

See if decompling your Db helps.

 

[ted.martin]

Just a thought - if you have an old/previous backup - then the front-end where all the code is should be ok. Just connect it to the present back-end.

 

[spowers21]

The problem is the old/previous backup does not have all of the modules that I have just created. One wierd thing that happens when I try to go into the design view of a module, I get the corrupt message for the first two or so clicks and then a message pops up and says "...the module or macro is mispelled or does not exist...". Any ideas??

 

[ted.martin]

Take a look at the Tables section of this forum. Sticky may have the solution.

 

[modest]

Try decompiling as Allan suggested.

 

[RuralGuy]

If you need /decompile instruction, then you now have it.

 

[spowers21]

Thanks. I'll have to try later today. It is a project that I am doing on the side. In your experience does decompile usually fix vba corruption problems?

 

[RuralGuy]

Everything is worth a try. One of my applications just corrupted while I was doing some housekeeping and /decompile fixed it.

 

[spowers21]

No luck. I have tried to compile my db and I still get the corruption message.

 

[RuralGuy]

Did you mean /decompile?

 

[spowers21]

Decompile, sorry. I sent my db to Everythingaccess.com and they could not recover all of my modules so I looks like I am starting over. Thanks for everyone's help.

 

[RuralGuy]

Have you tried this site's revenue source?
http://www.access-programmers.co.uk/ms_access_repair.htm

 

[Daveyk01]

If you need /decompile instruction, then you now have it.

Just did this.....Wow! The difference is huge! Thanks for those instructions. They definitely go in my Access notebook!!!!