password pattern match

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T J - 18 Aug 2005 03:29 GMT

hi - i've been asked to require a strong password in my DB
i.e. 8 chqaraqcters, upper and lower case letters, numerals and a special
character .
is there a way to require something like this in a table field?

Reply to this Message

Michel Walsh - 12 Sep 2005 20:22 GMT

Hi,

To the *field*, add the validation rule

LIKE "*[0123456789]*" AND LIKE "*[a-z]*" AND LIKE "*[<>+-]*"

for having at least one number, one letter and one of the 4 mentioned
special characters.

To the *table*, add the validation rule:

StrComp(UCase([Password]),[Password],0)<>0 AND
StrComp(LCase([Password]),[Password],0)<>0

To get lower and upper case letters. I assumed the field name was password.

Add the appropriate Validation Texts. Add security and data encryption.

Hoping it may help,
Vanderghast, Access MVP

> hi - i've been asked to require a strong password in my DB
> i.e. 8 chqaraqcters, upper and lower case letters, numerals and a special
> character .
> is there a way to require something like this in a table field?

Reply to this Message