Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    Access hangs whilst running queries (2000SP3)

    I'm having a lot of new problems with access hanging. Large database with lots of objects. Problem occurs when switching to datasheet view of new query or old query with unsaved changes to design. I don't think it's happened yet when running saved, unchanged query. Hang is a do nothing hang - no memory use change, CPU use or page faults change evident in task manager. Occasionally the explorer shell (task bar etc) hangs as well, but keyboard and mouse still work, and can switch to other apps using task manager and they're all working fine. Background apps just KerioPF, NAV2003, proxomitron and nvidia settings app.

    The queries have mostly involved at least one field generated using a built in or user defined function (happens with either), but I will have used the same functions during the same session without this problem occurring.

    Compact and repair db every time this happens. Still occurring after restart, and have tried repairing office, but still have same problem.

    I'd really, really like to avoid a clean reinstall of office if possible. Has anyone else had a similar problem, or have any explanations or any tricks to suggest?

    Thanks

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access hangs whilst running queries (2000SP3)

    Mark,

    I had a similar lock up yesterday and after opening and closing, repairing I found that I had a form hidden, open and modal. Once I changed it to unhidden (under the Window menu option) all was well.

    May not be the same thing but worth a look.
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

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

    Re: Access hangs whilst running queries (2000SP3)

    You might also want to import all of the objects into a new database - that often spotlights a corrupt object, or cleans up storage nicely. Also, if it isn't split into a FE and BE, I would do so post haste.
    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
  •