×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access 365 - Only allow one user to open

Access 365 - Only allow one user to open

Access 365 - Only allow one user to open

(OP)
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!

RE: Access 365 - Only allow one user to open

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/off...

For Microsoft 365, see: How to revert to an earlier version of Office 2016 Click-to-Run
https://support.microsoft.com/help/2770432/how-to-...

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

RE: Access 365 - Only allow one user to open

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

Jerry

RE: Access 365 - Only allow one user to open

They are working on it.

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

RE: Access 365 - Only allow one user to open

Recent news

Quote (MS)

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

RE: Access 365 - Only allow one user to open

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

JerryR

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close