Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    9

    Unanswered: "Could not lock file" error

    I have a mulit-user Access database where I have a single user who gets the error "Could not lock file" when trying to open the shortcut to the database. Users should not be opening the database for exclusive use which is what the message sound like to me. I'm just trying to figure out what's causing this? A setting on their local PC, something with the link? I'm more on the non-tech side but trying to help the user out on this. None of the other dozen plus users have a problem. Any suggestions would be appreciated.

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    After a quick google search, found these possibilities:

    Possibility 1

    Possibility 2

    Microsoft Help


    Amazing what a Google search can do isn't it
    Me.Geek = True

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I had problems with the last one above (http://support.microsoft.com/kb/305995) and use a vb-script to clone and launch the mdb to get around it (see code bank if you're interested.)

    Regardless, your problem sounds like Possibility 1 or 2 above (if it's 1 specific user and no other users have problems and that user gets the error every time.) If it happens randomly with this user (and other users), it could then be another specific user which is locking the mdb when they open it. I had it once where when 1 specific user got into the mdb, they locked it for other users. It was because this specific user didn't have write permissions to the folder (they only had read permissions.)
    Last edited by pkstormy; 12-03-08 at 19:47.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    has the user got write access to the folder in question
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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