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

John,

Some of my current DBs don't even prompt for Username and PW anymore.  I maintain a table that has Username/DisplayName/Permissions...when someone opens the db...I grab their windows username...check against the table...and grant necessary permissions.  If their ID is not in the table...the DB just closes.

BUT...be carefull...first time I used this configuration...I forgot to create my own account with 'admin' permissions...and locked myself out.

Good Luck,

Mark A. Matte


> Date: Wed, 5 Mar 2008 14:26:27 -0500
> From: John.Clark at niagaracounty.com
> To: accessd at databaseadvisors.com
> 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

_________________________________________________________________
Need to know the score, the latest news, or you need your Hotmail®-get your "fix".
http://www.msnmobilefix.com/Default.aspx