Database crashes after table update

[AccessJunkie]

My 886 Mb access database crashes at any time I use the form I use to navigate it as the main menu. This just happened after I updated one of the tables. If I don't use the form, everything goes well. This is my most recent problem.



However, I've had this issue of not being able to compact and repair this database for a long time. Every time I try it, it freeze up on me. This database is on one of our network drives. I tried to copy to my hard drive and it also hang up!

I am at the end of my rope here. Help!

[RuralGuy]

Useful links:
http://allenbrowne.com/recover.html
http://allenbrowne.com/ser-47.html
http://allenbrowne.com/ser-25.html

[AccessJunkie]

These links were very useful. I resolved my problem.

[RuralGuy]

Excellent! Glad we could help.