Cannot open anymore databases - Access database

Question

I am using Office 365 and running Windows 10 pro Version 10.0.19043 Build 19043. My processor is: AMD Ryzen 9 5900X 12-Core Processor, 3701 Mhz, 12 Core(s), 24 Logical Processor(s).

This morning I used an Access database application that I use every morning but got the following message:

Cannot open anymore databases

There have been no changes to the database for sometime and up until this morning it worked fine.

When trying to compact and repair the database I get the following message:

You attempted to open a database already open by user Admin on machine ....

I have restarted the machine and tried repairing Office 365 both to no avail.

When right clicking MS Access on the taskbar and selecting the database I had to do it several times this morning before the database opened. I am wondering if in someway this has screwed the system up.

I also notice that the lock files are trying to synch (with OneDrive?) and cannot be deleted - I get the message below:

Can anyone shed any light on how to solve the problem?

Many thanks.

Answer 1

Hi all,

According to the description this issue was applied after the latest update of Access to version Version 2201 (Build 14827.20158). Microsoft is aware of the bug and currently working on a fix. Please refer to this article for the information and a workaround Access is unable to close and leaves lockfile active (microsoft.com)

In case you want to revert to a previous version you can find the detailed steps here How to revert to an earlier version of Office (microsoft.com)

Sorry for the inconvenience.

Best Regards,

Igor

Answer 2

Take a look at https://www.devhut.net/another-access-bug-cannot-open-any-more-databases/ as it has 2 known workarounds.

Answer 3

I have sent my feedback to MS.

I too cannot revert to a previous version. I have tried repairing the current build 16.0.14827.20158, then rebooted, then followed all of the steps only to get an error message 'Something went wrong' Error code 30183-27 (400) and a link to follow which basic tells you to do everything I have just done!

I have also tried setting the Trusted Folder and subfolders as suggested elsewhere. That had no impact either. So now I seem to be stuck. Perhaps the only other action is to uninstall office and reinstall.

Answer 4

I uninstalled and reinstalled office. It did not help. Adding trusted folders did not help. I added feedback. I sure hope Microsoft can fix it fast, as no work around has worked for me.

Answer 5

Did you create a Trusted Location for the Back-end with the Trust subfolders enabled?