[AccessD] Number of Users

Rocky:

Some years ago, I had to do this.  There may be better ways, but what I done
then was.

1. Set up TWO custom property on the BE (say, MaxUSersAllowed,
UsersLoggedOn).
2. Set the MaxUsersAllowed to the appropriate value.
3. Each time a FE opened, it checked the UsersLoggedOn against the
MaxUsersAllowed and if it was at the max value, it gave a message and closed
down the FE else it increments this value.
4. Each time a FE closes, it decrements this UsersLoggedOn value.  If at
zero, it left it alone.( see below).

You will need a mechanism to clear down the UsersLoggedOn value as it
sometimes happens that people "bomb out" of the FE and the UsersLoggedOn
value is not decremented properly.

I therefore had a separate mde (compiled so no user can access the code with
password access for the SyAdmin) which when run, resets the UsersLoggedOn
value to  0 and close the BE (thus dropping all connections).  With suitable
messages/warning first of course. (ie, Get everybody out of the system 'cos
it is shutting down, etc)

HTH

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Sunday, January 06, 2008 4:19 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Number of Users

Dear List:
 
What is the easiest way to restrict the number of users in a FE/BE
application?
 
MTIA
 
Rocky
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com