Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 97 strange behavior (Access 97)

    We are using A97 on Windows 2000. This morning, for some reason, one of our databases became "exclusive", locking everyone else out <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> . We ended up rebooting the user's system and it seemed to fix the problem, although we couldn't figure out why a commonly shared database would suddenly stop wanting to share. No, the user didn't know any Access tricks, they were just running a process out of VB 6.0 which never before had this problem.

    This sudden "exclusive" error happened on and off all morning, to different users and systems. The latest was a database I was working on. As best as I can recollect, I accidentally opened it twice, but closed one instance. I then imported a table from another database, and clicked the Design mode - I got the message that I was using this table in exclusive mode and that I couldn't modify the design. Other than having an evil twin hanging around <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> , does anybody have any clues as to why we would be having this problem all of a sudden? <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Carpy Diem, it&#39;s .

  2. #2
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Adelaide, South Australia, Australia
    Posts
    146
    Thanks
    5
    Thanked 5 Times in 5 Posts

    Re: Access 97 strange behavior (Access 97)

    I don't know if it's the same in Access, but when I get similar problems in other Office applications I find that, on using Ctrl+Alt+Del and checking the Task List, I often have a "ghost" instance of the application running. I usually close all windows to the application, then remove any remaining references to it from the Task List. It usually happens after some kind of application error, and I don't know what would be causing it with your system, but it might be worth checking this before getting the user to reboot.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 strange behavior (Access 97)

    Thanks for the suggestion. We think it was a bad table, but then this morning (Monday) another application re-numbered a bunch of entries so I have to spend the rest of my day renumbering them correctly. Since the Monday nasty db had a link to the same bad table, it's probably the reason, but the numbering sequence has nothing to do with that table. I just wish we knew why we had the problems last Friday, so we'd know what to do next time. <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>
    Carpy Diem, it&#39;s .

Posting Permissions

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