Making a Text Field Case-Sensitive (Password)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

In my tblUserAccount, I've a field Passwrd, the input mask for which is
"Password". In my Sign-On form, the TextBox for Passwrd is also masked for
"Password." However, I've observed that this field is not case sensitive when
I'm trying to validate it using DLookup. Please help.
 
One approach is to use DLookup() to retrieve the stored password for
that username and then use StrComp() to test it case-sensitively against
what the user has typed.

BTW, it's not such a good idea to store the actual passwords in the
table. Instead, use a hash function to irretrievably scramble the
passwords and store those values. For validation, use the same hash
function on what the user has typed and compare it with the stored
value.
 
Hi John,

Thank you for the suggestions. Both the ideas make a very strong case to
revise my idea of Security in Access. But, I couldn't muster enough courage
to mess around with WorkGroups and hence this simple solution.

The Hash Function idea is great, can you please give some examples/pointers ?

Thanks again.
 
Back
Top