Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 365 - Only allow one user to open 1

Status
Not open for further replies.

JerryR

IS-IT--Management
Mar 22, 2017
9
US
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!
 
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

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

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Thank you!! Can't seem to get it working. Hoping MS fixes it soon.

Jerry
 
Recent news
MS said:
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
 
It is now working after the latest updates!! THANK YOU THANK YOU THANK YOU.

JerryR
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top