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

Instead of having the user login, you can grab the AD login name and
assign security parameters to that.  On the load event of the main form,
grab the AD login name and match it with the access rights assigned. 
You'll need to have a table (and a way to modify it, through the UI),
with the user's Display Name, Login Name, Access Rights, and anything
else you want to control.  For example, in one of my databases, I
control who has the privilege of creating notes and/or who can get to
some of the financial data on the forms.

Jim
jhewson at nciinc.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 1: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
################################################################################

This email transmission contains information from NCI Information Systems, Inc. 
that may be considered privileged or confidential and is intended solely for the 
named recipient.  If you have received this message in error, please contact the 
sender immediately and be aware that the use, copying or dissemination of this 
information is prohibited.

################################################################################