Results 1 to 2 of 2
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,521
    Thanks
    3
    Thanked 50 Times in 50 Posts

    Hung Access - any ideas (2002 sp2)

    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>
    Wendell

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,521
    Thanks
    3
    Thanked 50 Times in 50 Posts

    Re: Hung Access - any ideas (2002 sp2)

    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>.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •