DB Crashing

[apoll0]

So here's my situation: Tonight I opened the file I was working on this morning (which was in perfectly fine state)...

I opened a form - CRASH!!
I press ALT+F11 to go to the VBA editor - CRASH!!
I open another form - it works fine... So i select a button and tried to edit the action script - CRASH!!
I relinked the backend file - CRASH!!
It seems everying I do makes the darn thing crash.

I tried compacting/repairing - no luck there. This is not the first time it has happened to me. I forgot how i managed to fix it the first time. Anyone with experience with this? Any suggestions?

I tried opening an older db file, and was able to access the VBA editor for that file. But it crashed again when i tried going back to the bad file.

If i recall correctly, I think this morning, when I closed my access file, I closed the Access Program long before I finally closed the VBA editor (didn't realize it was still around because the taskbar was a bit cluttered). Wonder if that caused it to go hay-wired.

 

[apoll0]

Problem fixed.

I tried opening a particular form in design view and it always crashes, all the other forms didn't. Opening any other form that contains the damaged form as a subform aslo crashes the program.

So I went to the backup I made yesterday (luckily) and replaced the damaged one. Wonder what can I do to avoid this in the future.

 

[Ron_dK]

Just some notes :

When designing a dbase form or what ever thru VB, make sure that
after changes made, you hit the Debug > compile YourDbase. If done, close the VB editor, return to the design mode in Access and save your ( changed) form.

Return to Form View, go to Tools > Database Utilities and do a compact / repair.

If crashes keep coming up, make a new Database and import all objects from your Dbase to that new one and repeat the Debug and Compact/Repair actions.

 

[apoll0]

thanks rak