Why is Access 2003 crashing and corrupting the database?

[MonsterMaxx]

I continue to have access crash, very frequently. On a system that's otherwise fine. Access is fully up to date with the latest patches, but it frequently says it's out of memory (though the system hasn't used half what's available) and it crashes.

Sometimes it corrupts the database such that nothing can repair it and i have to go to another copy. It's usually a form that can never be opened again and if I do will instantly crash access or it does nothing when I try to open the form.

What's the deal?

It's just corrupted my main form and I have to go back to yesterday's database. I've lost an entire day's work.
It completely crashes every time I try to open the form.
I've even gone so far as to delete the form. Perform a repair/compact. Then tried importing the form from the known good database, it crashes on import.

Is there anything I can do or did I lose a day's work?

 

[georgedwilkinson]

You can try to link to the corrupt database tables and recover the data.

You can try to enter the corrupt database holding the shift key.

You can try compacting, repairing, and compiling the corrupt database if you can get into it.

You should look for code that may be running "in the background" of your database that might be making recursive calls or be in an endless loop or creates a lot of objects (possibly with recursion or iteration) without releasing the objects.

There are so many things you can do. At any rate, you should make sure you aggressively fix it so it doesn't happen again. One thing you should definitely do is split your database. That way, your data is separated from potentially corrupt forms.

 

[MonsterMaxx]

There isn't a lot code in the database. I really don't think it's in the code since what I've done today has nothing to do with code.
I think this form is just corrupted somehow.

I can't even open the form in a design view. How can that be code related?

Yes, I'll split them soon, but it's a PITA when you are still in early dev to have them split.

I guess I'm just screwed and have to do today's work again