Check Secure DB User Passwords

[Tony_VBACoder]

In Access 2002, I want to be able to check when a User
logs into my Secured Access 2002 application that they
have a password. How can I check if the CurrentUser has a
password or not?

 

[Joan Wild]

You can try to open a DAO workspace in code
using the CurrentUser() function for the user name, and a blank
password for the password argument. If the password is not blank,
you'll get an error which you can trap and ignore since they have a
password. If you don't get an error, you know the password is indeed blank
and can do something.