Access 2003 Crashing Constantly

[chammock]

I have been working on a fairly complex Access 2003 application for the
last few weeks. A couple of times I have created an empty db and
imported all the objects from my app into the blank db. I read
somewhere that this might help keep the app from getting corrupted.

Anyway, a couple of hours ago Access just started crashing about every
10 minutes or so and now it will open my app, but some macros are not
executing correctly and anytime I try to run some functionality I get
the dreaded MS Access has encountered a problem and must shut down. I
tried the Debug option and got this.

Unhandled exception at 0x7c911ec3 in MSACCESS.EXE: 0xC0000005: Access
violation writing location 0x0ad7702a.

I don't have any other complex apps to run to test, but some of my
basic Access apps run OK. It seems to run a version from earlier today
OK as well. It makes me think it could be my code. I have commented out
most of my latest code to see if that will help but it still crashes.

Is this most likely an issue with my application or with Access? Could
my app have been totally corrupted or is is probably a piece of code
that I could correct and get it working again?

Should I consider removing and re-installing Access?
I have Access at home. Maybe I will leave work and try to run it there.
Thanks for any help you can provide.

 

[chammock]

I found a post recommending a decompile to get the code in sync with
the compiled version. I did that but it still crashes. I also turned of
the AutoCorrect name thing. Any other ideas.

 

[John Vinson]

I found a post recommending a decompile to get the code in sync with
the compiled version. I did that but it still crashes. I also turned of
the AutoCorrect name thing. Any other ideas.

Check the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson[MVP]