[ms office - 2016] Microsoft Access Record Locking Stopped Working

[AB_IT]

Hello All,

 

Hoping one of you guys can help as we're all really stuck. We have two RDS servers that everyone logs into and installed on there is Office 2016 with Access. We have quite a few Access Databases setup on a seperate File Server (Shared Area) that everyone uses to input data into.

 

Recently we've had an issue whereby the access database won't allow multiple users to edit the databases and instead gives exclusive access to the first person who accesses the database. From what I can see nothing has changed and we haven't had any recent updates to the servers in the past few weeks. Permissions for the users are all good also.

 

I've found this online https://techcommunity.microsoft.com/t5/report-an-issue/microsoft-access-record-locking-stopped-working/m-p/3039990 which seems to describe the same issue I'm having but there's not much info on how to fix it or any definite answer.

 

Is anyone else having similar problems?

 

[TomFreeman]

We've had similar issues and are currently testing this:

 

Databases on network share can't be accessed by multiple users in Office 2016 (KB4484211) (microsoft.com)

 

Can't be deployed by WSUS though, it's manual download only.

Edited January 11, 2022 by TomFreeman
Additional Comments

[AB_IT]

Thank you I'll give that a go. I removed an update KB5002099 in the end which resolved the problem for now. If you have any luck with the above would you mind kindly letting me know and I'll trial it then.

[TomFreeman]

Manually installed on a handful of machine in one IT suite that's having the issue and have had responses this morning that seems to have solved issue for us. Ours are all single access though not got any that have multiple people accessing, but were receiving same errors.