[AccessD] Creating a Login form & check PW...how?

Thanks John. I think I will try this approach.
 
Sorry for the delay getting back to you...I got tied up w/some personal junk.
 
John W. Clark
Computer Programmer 
Niagara County
Central Data Processing
         


>>> "jwcolby" <jwcolby at colbyconsulting.com> 3/6/2008 1:22 PM >>>
John,

I highly recommend that you go one step further and do a full on group /
user / groupuser system.

tblUser
USR_ID
USR_Initials
USR_Name

tblGroup
GRP_ID
GRP_Name

tblGroupUser
GU_ID
GU_IDGRP
GU_IDUSR

Now you can create groups at will, and users at will, then assign users to
groups.  All basically just like in Windows itself.

However I find it useful to have database groups separate and distinct from
groups at the windows level.  

I decided to write a demo of how to do this and am almost finished.  I will
make it available tomorrow when I am done.  I have what I call my
LightWeight Security system embedded in my framework but like many things, I
was not happy with my first pass.  The version I am just now finishing looks
much more polished and easier to comprehend and use.

Anyone want to be a beta tester?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Wednesday, March 05, 2008 2:26 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Creating a Login form & check PW...how?

Easy one for y'all...(A03 by the way)

I'm trying to add a login screen to a current db, so that I can divide users
into three groups. Depending on your group, different buttons will be
enabled/disabled. 

So far I've got a table (tblUsr) where I've got the individual
users...txtUsrID, txtPW, txtSecLevel. I have a form w/they can type in their
ID and PW, but I'm having trouble figuring out how to check that they have
entered the correct PW.

I figured this would be easy enough, and I thought I did it before, but I'm
struggling here.

Thanks! 
JClark

PS...I haven't been out here much, because my programming duties were scant,
but I've been assigned a couple more programs, so I'll probably be a pain
again, until I get my wings back ;o)




John W. Clark
Computer Programmer
Niagara County
Central Data Processing
         
--
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