password pattern match

[T J]

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?

 

[Michel Walsh]

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