Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008

    Unanswered: Issues with locked MDB

    I am calling a VB app from Access. The VB app needs to run queries against the MDB. However, when I try to do that I receive a "locked by another user" error.

    How can I access and MDB then that is already open.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    make sure its not opened exclusive by another user
    make sure you are not trying to open it exclusively

    you can query the lock fiel to find who has the app open, and then by a process of elimination (a baseball bat to the head often works) you can find out which users are opening the db exclusively. Of course if its yourself then keep very very quiet and blame the network trolls....
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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