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

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