Could not lock file in Ms Access

Posted on 2008-11-19
Last Modified: 2013-12-04
Using Ms Access 2003 created an mdb file, put it on a folder on the server. When trying to open the mdb from a client who has full control authority to the shared folder we get "Could not lock file" Using Windows 2003 Server sw, Windows XP and Vista on clients.
Question by:imaksu
    LVL 9

    Accepted Solution

    The problem is that the user can't lock the .ldb file. You say you hev given people the Full Control Share permission. You also have to set the read-write permission on the NTFS level that's where you're problem resides.
    The shared folder permissions should always be put on full control and you should set the actual permission in the securitytab.
    LVL 84
    Also make sure your permissions are inheritable by the files you place in this folder.

    Also, you should provide for EVERY user a COPY of the database, and not allow them to share it. If you allow users to share, then one user can lock everyone out. IOW, split the database, place the Backend (Tables only) on the server, and deploy a FrontEnd (everything else) to each user.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Container Orchestration platforms empower organizations to scale their apps at an exceptional rate. This is the reason numerous innovation-driven companies are moving apps to an appropriated datacenter wide platform that empowers them to scale at a …
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now