[AccessD] Restrict # of User Logins to Access

Greg S weeden1949 at hotmail.com
Mon Aug 18 14:18:17 CDT 2003


Charles:

Well, phooey.  Once again I made myself NOT clear...like mud.  Sorry.

What I meant was the same username (Phred, for example...), can't be logged
into the db more than once, at the same time.  Regardless of what terminal
or workstation they are on.  If Phred is in the DB once, another user (or
the same one at a different computer) can't login with Phred again.

And, now that you mentioned that, she also did say she wanted to restrict
their times in the database.  The database is online within their offices
24/7, except during backups, but she wants to restrict them to using it
from, say, for example, Monday through Friday, 0900-1500, only.  I haven't
thought about that too much yet, but it might not be too hard to implement.

Greg


----- Original Message ----- 
From: "Wortz, Charles" <CWortz at tea.state.tx.us>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, August 18, 2003 1:20 PM
Subject: RE: [AccessD] Restrict # of User Logins to Access


Greg,

Once in a lifetime?  Or once in a day?  Or once in an hour?

If it is the first, then you have a separate table with flags you set
for each user.  Once the flag is set, they are locked out forever.  For
the latter options, you add a date/time field to record when they
accessed and then compare the time of their next attempt to access to
see if the proper length of time has expired.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Greg S [mailto:weeden1949 at hotmail.com]
Sent: Monday 2003 Aug 18 10:53
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


More information about the AccessD mailing list