Results 1 to 2 of 2
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,497
    Thanks
    3
    Thanked 42 Times in 42 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. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,497
    Thanks
    3
    Thanked 42 Times in 42 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
  •