1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access: Could Not Lock File Error

Discussion in 'Business Applications' started by dfriend846, Sep 13, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. dfriend846

    dfriend846 Thread Starter

    Joined:
    Aug 11, 2005
    Messages:
    208
    We have an Access database on our network which about 2-3 of us use concurrently. This is not a problem for us. One person cannot access it because of a, "Could Not Lock File" error. The rest of us do not have this problem. Can anyone tell me how to correct this? Is the problem in the person's security or configuration of Access or in the database?

    Thanks.
     
  2. dfriend846

    dfriend846 Thread Starter

    Joined:
    Aug 11, 2005
    Messages:
    208
    Here's an answer to the above problem: The users who had problems opening Access had read only rights for the network folder containing the database. If they were the first (only?) user then there was no problem but if they logged on as a multiple user the program could not create a lock file since they did not have write priveleges. When changed to allow write priveleges the problem went away.
     
  3. Adeyan

    Adeyan

    Joined:
    Jan 4, 2007
    Messages:
    9
    Thanks, exactly what i was looking for :)
     
  4. glisando

    glisando

    Joined:
    Jun 1, 2007
    Messages:
    15
    I am having the same problem in my workplace too. I just took over the admistration of the database recently. There is a user who always gets the 'could not lock file' error

    Is giving them 'write' privellages the only way to solve this problem? What if that particular user is not supposed to do any editing of the data, and I end up giving him 'WRITE' privellages?

    Could it be something to do with the registry settings of the user's notebook/PC? I managed to get some info from this site : http://support.microsoft.com/kb/305995
    Could anyone confirm that the method suggested by the above mentioned link will solve the problem?

    Thanks.

    regards
    glisando
     
  5. dfriend846

    dfriend846 Thread Starter

    Joined:
    Aug 11, 2005
    Messages:
    208
    Hello Glisando,
    I'm sorry but I cannot confirm that the other method will work. In my 2005 note I referred to the Write priveleges of the folder on the network. There are ways to prevent people with Write priveleges from altering data. In my case the users access the data via forms and those who should not change the data use forms where the fields cannot be edited. None of this will stop a determined with a little knowledge.
     
  6. glisando

    glisando

    Joined:
    Jun 1, 2007
    Messages:
    15
    Hi Guys...

    In that case I will procceed to give write privellages to the users. Guys, in the server there are a few files like MSACCESS.EXE, application.mdb, Security.mdw, MSACCESS.EXE.dsn and application.mdb.dsn. I right clicked on 'application.mdb' and than clicked on the 'security' tab. Under the 'Group or user names' section I see a list of names. Below in the 'Permissions for 'Staff Name' ' section, I can see the types of permission given to each individual user. Now I thought all I had to do was to click on the 'allow' tab for the 'write' permissions. When I clicked it, it was a green coloured tick and not greyed out like the other ticks meant for the other permissions. I cliked 'apply' than 'ok'. However the user still has the same error has before. Is there anything else I should do to rectify this problem guys?


    regards
    glisando.
     
  7. cristobal03

    cristobal03

    Joined:
    Aug 5, 2005
    Messages:
    3,086
    I was under the impression dfriend846 meant establishing write permissions for the Windows user to the network folder, not creating write permissions for users within Access's own security features or to the database file itself. Windows users must be able to write to the folder where the database resides in order to create lock files.

    HTH

    chris.
     
  8. glisando

    glisando

    Joined:
    Jun 1, 2007
    Messages:
    15
    Hi...

    I read your posting. Thank you very much. I went to the network folder, I right clicked and selected properties. I clicked on the Security Tab. In the 'Group or user names' section, I clicked on the user name and in the 'Permissions for user' section I clicked on the 'Allow' box for 'write' (Read & Execute, List Folder Contents and Read were already selected). I clicked on the 'Advanced' tab and under the user's name I find that all the the necessary permissions have been selectcted, just like in the case of the users who do not have the 'could not lock file' error.

    Just to make sure everything is ok, I went into the folder and right clicked on the application.mdb. I selected the user's name and I found that in the 'Permissions for user' section, I found the tick in the allow box for 'Read & Execute' and 'Read'to be in green and the tick for the write box greyed out. I found this strange as for the other users, the ticks in all three boxes were greyed out. The other thing I noticed was in the Advanced security settings, for this particular user's name, the 'Inherited from' column says : not inherited. I than clicked on Edit to see the permissions allowed and was very suprised to see that 'create files/ write data', 'Create Folders/Append Data' , 'Write Attributes' and 'Write Extended Attributes' boxes were not selected. I am quiet confused, anything else I should do?

    regards
    glisando
     
  9. glisando

    glisando

    Joined:
    Jun 1, 2007
    Messages:
    15
    Hi Folks...

    I have to add a new user to the database. This is what I tried:

    I right clicked on the folder holding the database. I selected properties. In the general Tab, there is an option called 'add'. Is this the way to add a new user for the databse?

    However I read in the Ms Access 2003 bible that I have to go to Tools, Security, User and Group Accounts to to add users, however I face a problem. If I go into the folder and double click on the database.mdb file, I get a message that says that I dont have enough permissions to use the object , however I have all the permissions set. What should I do?

    regards
    glisando
     
  10. dfriend846

    dfriend846 Thread Starter

    Joined:
    Aug 11, 2005
    Messages:
    208
    Hello Glisandro,
    Unfortunately I was able to answer my initial question but I do not have enough experience to address your questions. Cristobal was correct (June 6) that my problem related to network read/write access for the user. This can be tested by opening the folder of interest from the user's machine and creating a file. An easy way to do this is to right click on the empty space, then choose new, text document. You should be able to create a txt file and then erase it. If you cannot do this then you will need to change settings before proceeding to Access.
    I have not tried to use the database.mdb file.
     
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/398720

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice