A tip for the paranoid

[BobWeaver]

If you are setting up your own user access/password system rather than using Filemaker's built-in access privileges, and you allow the users to select their own password, here is a simple calculation to check for insecure passwords. Set up a global field called gInsecureText and enter the following text:

"qwertyuiopasdfghjklzxcvbnm

poiuytrewqlkjhgfdsamnbvcxz

abcdefghijklmnopqrstuvwxyz

zyxwvutsrqponmlkjihgfedcba

1234567890987654321"

Then you can test a Password as follows:

Case(Length(Password)<6 or PatternCount(gInsecureText,Password)>0,"Bad","Good")

This returns "Bad" if the user picked a password less than 6 characters, or an easy sequence of keyboard strokes like "qwerty" or "abc."

Since you can expand the contents of gInsecureText up to 64,000 characters, you could add in company name, employee names and other common insecure words, etc.