[AccessD] Number of Users

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Sun Jan 6 11:54:23 CST 2008


 
Max:

Looks like a good approach.  Avoids the Access workgroup and security
thingies.  Always a plus.  The max users I can embed in the product key.  

Thanks.

Rocky




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Sunday, January 06, 2008 9:09 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release Date: 1/5/2008
11:46 AM
 




More information about the AccessD mailing list