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

Hi Chrisjo_2015,

Thanks for posting in the community.

According to your description, I would like to collect more information.

1. Please provide your Office version

Click File> Account, take a screenshot including Subscription Product and About Access

2. May I reconfirm whether the issue exists in a specific database or also in other databases?

Regards,

George

Answer 3

Office version:

Currently I have only experienced the problem in one database application (which actually consists of two linked databases - one db holds the code and the other the data).

Answer 4

Just started using another database and I get the same problem .... basically my databases have become unusable!!!

Answer 5

After seeing this post while researching these exact symptoms, I notice that the Office Suite had been installed today 2/2/2022.

I rolled back to prior version and the issue went away. I'm looking into ways to block office for all systems.

https://www.urtech.ca/2019/10/solved-how-to-roll-office-365-pro-plus-back-to-a-previous-version/

Rolled back office from 16.0.14827.20260

OfficeC2RClient.exe /update user updatetoversion=16.0.14729.20260