Jim Lawrence (AccessD)
accessd at shaw.ca
Mon Aug 18 19:23:02 CDT 2003
Hi Greg: I had a similar situation and used a piece code that acquired the user's ip address and their user name. The ip was stored in a invisible table, in a row, adjacent to the user's login name. If the same user and/or another session was spawned from the same address, the last connection was automatically logged off. Worked well for years. If you would like some of code chunks, I can sent it along...maybe off-line. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Greg S Sent: Monday, August 18, 2003 8:53 AM To: Access Developers discussion and problem solving Subject: [AccessD] Restrict # of User Logins to Access Hello everyone! I got a request from a client that I'm not sure how to handle...and I hedged enough so as NOT to commit to anything until I have it figured out. Their current system is in Access 97, using full Access's security. It's setup fairly well, with users being members of groups and rights assigned to the groups. Now she's thrown me a curve. She wants to allow users from another department to login to her system, but ONLY ONCE (her reasoning is sound - she does not want users from another group tying up all her resouces and licenses with multiple logins). That is, that username can only login to the Application once...one concurrent usage. Windows security would do this easily, but Access 97's doesn't have a place to select the number of logins per user. Any suggestions on how to do this? I've just had a second temporary crown put in this morning (since last week), it's fairly early, I've NOT had sufficient coffee, and I'm a bit fuzzy (fuzzier??) around the edges this morning and it's not readily apparent to me on how to do this. Thanks!! Greg Smith weeden1949 at hotmail.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com