Hung Access - any ideas (2002 sp2)

[WendellB]

I've got a session of Access running on a Windows 2000 system that is hung - but the Task Manager reports it as running, and not "not responding" - and I can't seem to break it with CTRL-BREAK. None of the forms will respond - it thinks there is a pop-up form that has control, but I can't get to the pop-up form with ALT-TAB. The form shows up in the sequence however - so I suspect I have some rogue code running somewhere. I fear if I kill the form that appears to be in control, then Access will shut down, and odds are I'll have a corrupt database and get to start over with about 6 hours of work to reproduce.

Any suggestions? <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22> <img src=/S/scream.gif border=0 alt=scream width=15 height=15> <img src=/S/weep.gif border=0 alt=weep width=21 height=16>

[WendellB]

Whew! I'm not <img src=/S/cooked.gif border=0 alt=cooked width=50 height=46> after all. I was able to copy the database to another file even though it appeared to be hung. I then killed the forms one after another and finally killed Access and rebooted, and miracle of miracles, the database wasn't corrupt, or at least I was able to compact and repair it. The problem appeared to stem from code that was trying to run after a pop-up form had been opened and closed, and Access didn't seem to know enough to throw an error that it couldn't refer to a closed form. For what it's worth - probably not more than <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>.