Access 365 - Only allow one user to open 1

[JerryR]

I have been using a database for several years now. It has a Backend on the server and a Frontend on 5 workstations. Started yesterday, only one person can logon. When the next person goes to log on, they get a Macro Single Step on AutoExec. Then database halts and won't run.
No matter which workstation logs on first the others get this message.
There has been no permissions changed nor any updates when this started. We did try updates after to no avail. All workstations are Windows 10.
Have ensured that the Shared option is selected. Checked all permissions and they are okay.

Anyone have any ideas?

Thanks in advance!

 

[dhookom]

You may be one of the many users experiencing this following the Tuesday security patch. The Access team is aware of this problem. For those affected by the latest patch adversely, here are instructions to rollback to an earlier version:

For MSI builds, see: Information about the ability to uninstall Office

https://docs.microsoft.com/office/troubleshoot/office/ability-to-uninstall-office

For Microsoft 365, see: How to revert to an earlier version of Office 2016 Click-to-Run

https://support.microsoft.com/help/...er-version-of-office-2013-or-office-2016-clic

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[JerryR]

Thank you!! Can't seem to get it working. Hoping MS fixes it soon.

Jerry

 

[dhookom]

They are working on it.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[dhookom]

Recent news

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

For anyone who has seen the issue on one of these channels, if you have the opportunity, please Update Now (it may not happen automatically) to get the updated version and validate that it addresses the issue.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[JerryR]

It is now working after the latest updates!! THANK YOU THANK YOU THANK YOU.

JerryR