File already in use Error

[sawdustmaker]

I have a split database that is in use from many computers.
Just today I am getting "file already in use" error from just one computer.
I copied a the same front end .mdb from another computer that it is still working on, but I still get the same error just from this one computer same .mdb.
Seems to be computer related, not mdb itself.

Crazy part is:
If I close the front end mdb on the computer hosting the back end mdb it works again from the problem computer.
But having the host computer mdb open does not effect any computers but this one.

Problem just started today.
No changes to computer that I am aware of.

Any suggestions would be appreciated.

Access 2016
Win 10

[pbaldy]

You may be running into this:

https://www.devhut.net/access-lock-file-issues/

[sawdustmaker]

Update - Seems these 2 computers cant be on the backend .mdb at the same time.
They seems to lock each other out but not the other computers.

[sawdustmaker]

Pdaldy - thanks for the heads up!
Do you know how I can find how to uninstall the updates for office 2016?
Cant seem to find it after much searching.

[Welshgasman]

See post #12 here
https://www.access-programmers.co.uk...update.320898/

[pbaldy]

A brief search turned up this:

https://answers.microsoft.com/en-us/...4-e6fecdf0534e

The link had the KB that needed to be uninstalled in it.

[moke123]

Guessing by the timestamps of your posts you may not have seen an update daniel posted at 1900 hrs.

from PBaldys posted link https://www.devhut.net/access-lock-file-issues/

Officially From Microsoft

We have an update as of 2021-12-16 at 19:00, a fix has started to roll out!
New builds with the fix have started rolling out for some channels:Current Channel: 16.13801.21092
Current Channel (Preview): 16.0.14729.20170
Semi-Annual Channel (Preview): 16.0.14326.20272
Semi-Annual Channel: 16.0.13801.21092
Semi-Annual Channel (Extended): 16.0.13127.21846

Shane Groff - Access Dev Team

So update your systems and things should be back to normal.