MS Access Lock file

Question

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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

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