Check Secure DB User Passwords

  • Thread starter Thread starter Tony_VBACoder
  • Start date Start date
T

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?
 
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.
 
Back
Top