Drew Wutka
DWUTKA at marlow.com
Mon Aug 18 14:06:51 CDT 2003
Okay, just put in the start routine a little piece that checks for the number of logged in users for that account name (against the .mdb). I think you need to see if there are two or more (because it should show up as 1 user before your code even fires). Then simply close the app if there are 2 or more.....(and prompt the user to tell them why you're shutting down...). Somewhere I have some code that breaks down the logged in users, from within Access 97, if you want me to dig it up, let me know. Drew -----Original Message----- From: Greg S [mailto:weeden1949 at hotmail.com] Sent: Monday, August 18, 2003 10: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