troubleshooting Question

MS Access Limit Number of Simultaneous Users to 10

Avatar of Mohamed Singh
Mohamed Singh asked on
Microsoft AccessProgramming
13 Comments1 Solution358 ViewsLast Modified:
In a multi - User environment,  I need to limit the number of simultaneous users to 10.
There are multiple back - ends on the server linked to each front - end on each users desktop.
A permanent open connection ( via linked tables to each of the back-ends) is created when the first form, frmDashboard opens.
(fsubDashboard1,  fsubDashboard2,  etc has tblLink1,  tblLink2 etc as the record source).
How can I prevent the 11th user from login - on,  seeing that only 10 users should be logged-on simultaneously.
Your assistance is greatly appreciated.
Kind Regards,
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros