Logon Password Verification

[MaureenKLM]

I have a FP 2002 Web with an Access 2002 Db

I used the ASP code in KB article 825498 to create a logon page with password.

All works in test mode so far EXCEPT that the password is not required to be
CASE SENSITIVE. The UserID is...but if I type in the password correctly
except for the case (i.e. I intentionally enter the text with the incorrect
case) it is still accepted.

Any suggestions or direction?

 

[Jim Buyens]

Instead of:

strSQL = "SELECT * FROM " & USERS_TABLE & " WHERE (UID='" & UID & "' AND
PWD='" & PWD & "');"

try:

strSQL = "SELECT * FROM " & USERS_TABLE & " WHERE (UID='" & UID & "') AND
StrComp(PWD, '" & PWD & "', 0) = 0

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------