MS Access Limit Number of Simultaneous Users to 10
Posted on 2014-11-18
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.