Access users in multi-user environment getting error "database is in use"

Microsoft has acknowledged that a security fix that went out on "Patch Tuesday (14 Dec. 2021)" is the cause of this problem.  Although nothing is posted here yet, my POC on the Access team at Microsoft indicates they will be posting info on this issue here: Access Fixes or Workarounds

The only current fix is to roll-back the effected user(s) to a previous build of Office.

For rollback instructions:
-  For MSI builds, see: Information about the ability to uninstall Office
-  For Microsoft 365, see: How to revert to an earlier version of Office 2016 Click-to-Run
0

Expert Comment

by:VSACIT
Hello,

This is still a problem, is there a fix that I'm missing.

Thanks,
VSACIT
0
LVL 58

Author Comment

by:Dale Fye
Microsoft published a fix but it will not automatically be applied.

You need to do a manual update of Microsoft Office.
0

Expert Comment

by:VSACIT
Hello Dale,


I ran the Online repair. Is this the same thing?

Thanks,

VSACIT
0
LVL 58

Author Comment

by:Dale Fye
no, this is an Office update.

you want to go to your account section.  In there, there is usually a way to view updates and manually run an update.
0

Expert Comment

by:VSACIT
Hello Dale,

We have our Office updates locked down in our GPO, and we allow iVanti to update our systems in our Organization. At this time the office update is at Version 2111 16.0.14701.20262, we are still experiencing the message "Could not use ‘path to database.accdb’; file already in use", and only one person can work in the database at a time.

I would appreciate it if you learn there is a fix.

Thanks,

VSACIT
0
LVL 58

Author Comment

by:Dale Fye
Then you need to advise your IT department or outsourced IT that there is a Microsoft fix but that they must install it manually.  Here is the link to the Microsoft Support page:
0

Expert Comment

by:VSACIT
Hello Dale,

happy New Year!  It appears that KB5008212 is the problem, I have removed this patch on 99% of my systems, and it has given me issues on one desktop.

I have not  seen any notification that their is a fix for this patch. If you have any insight that would be helpful.

Thanks,

VSACIT
0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month