Share via

MS Access Lock file

Deon Olivier 101 Reputation points
2022-01-10T13:58:06.163+00:00

Good day,
I have an Access 2016 database which is opened in Shared mode for multiple users.
Since 2 weeks ago, only 1 user can access the database at any given time as if the database is opened exclusive.

When I check the lock file ([Filename].lccdb), it is an empty file. Normally I would be able to see the user name and/or computer name that is accessing the database. I am also able to delete this file while I am in the database.

I have compacted the database, re-build the database from scratch, but to no avail.
NOTE: This only happens running the program (backend) from the server. If I copy the back end to my local disk, the lock file is generated correctly and more than 1 user can access the database.

Any suggestions?

Thanks
Deon

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
868 questions
0 comments
Accepted answer
  1. Karl Donaubauer 1,726 Reputation points MVP
    2022-01-10T14:24:40.883+00:00

    Hi,

    Since the bug has been introduced on December 14, there have been many discussions about it in every Access forum in the world. Just take a look here or elsewhere. The first reference you should read is the Microsoft support article.

    Servus
    Karl
    Access News
    Access DevCon

    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deon Olivier 101 Reputation points
    2022-01-14T10:14:25.907+00:00

    Hi Karl,
    After installing the updates, my problem dissapeared. Many thanks

    0 comments
  2. Deon Olivier 101 Reputation points
    2022-01-27T13:39:13.827+00:00

    Hi all,
    I have installed the fixes as per the Microsoft articles. 99% resolved, but there is one or two users' PC's that still gives the same error, even after installation of the fixes.

    Any suggestions?

    Thanks
    Deon

    0 comments
  3. Karl Donaubauer 1,726 Reputation points MVP
    2022-01-27T14:05:27.51+00:00

    Hi,

    Hard to say without your version/build/update channel etc. details - sometimes even with that information. ;-)

    In the moment there have been complete fixes rolled out for most variants but still only partial fixes (for direct UNC paths) for 2 Access versions and 1 update channel. The table in the support article has most details but there are even more updates in between. Could that play a role in your case?

    Servus
    Karl
    Access News
    Access DevCon

    0 comments
  4. Deon Olivier 101 Reputation points
    2022-01-28T07:07:00.03+00:00

    Hi Karl,
    I installed all possible fixes, but with no results.
    As you mention, my issue is with Direct UNC paths.

    I will continue searching for a solution, but if you come across anything, please forward to me.

    Thanks
    Deon

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.