Database no longer shareable

George_Hepworth 

Thank you George - I spent a good few hours chasing my tail trying to get to the bottom of that one. It was so recent that there wasn't really anything on the general internet that helped. I followed the instructions from MS on rolling back to an earlier version of office:

https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841

I settled on version 2111, build 1407.20226 and this works fine. I'm so glad I've only got about 6 PCs to do and not 60! How will we know when MS have released a fix I wonder?

Thanks again - I'm buying you a virtual beer!

Here's a detailed rundown and fixes for the following issue. Thank me later 🙂

Symptoms:
- You receive the following error when opening access "Could not use ‘path to database.accdb’; file already in use"
- Your database backend is stored on a network location.
- The laccdb lock file does not automatically disappear when all users have disconnected from the shared accdb file.

Affected Versions:
- Office 2019 Version 1808, build 10381.20020
- Office LTSC 2021 Version 2108, build 14332.20204
- Current Channel Version 2111, build 14701.20248
- Monthly Enterprise Channel Version 2110, build 14527.20340
- Monthly Enterprise Channel Version 2109, build 14430.20380
- Semi-Annual Enterprise Channel (Preview) Version 2108, build 14326.20692
- Semi-Annual Enterprise Channel Version 2102, build 13801.21086
- Semi-Annual Enterprise Channel Version 2008, build 13127.21842

Caused by:
Microsoft Jet Red Database Engine and Access Connectivity Engine Elevation of Privilege Vulnerability update.

Resolution:
This issue can be resolved one of 3 ways (See below);

1.) Removing the following updates;
- KB5002099
- KB5002104
[Note] This will only temporarily fix the problem until the next time office updates. You can disable the updates in File > Account > Office Updates > Disable Updates

2.) Reverting back to an older version of office by running the following command (elevated)
- Version 2013 – “C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe” /update USER displaylevel=True forceappshutdown=true updatetoversion=15.0.5397.1002"
- Version 2016 – “C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe” /update USER displaylevel=True forceappshutdown=true updatetoversion=16.0.14701.20226"
[Note] This will only temporarily fix the problem until the next time office updates. You can disable the updates in File > Account > Office Updates > Disable Updates

3.) Combination permanent build fix until next build change.
a. Revert back to last update (as seen above).
b. make a copy of the acecore.dll files. You can find these by searching your program files directories.
c. Update Microsoft office as normal using the File > Account > Office Updates > Update Now
d. Once updated, copy the acecore.dll files back into the original locations.

@Billspark1970 

@PeteHadden