Password expiring

[Wantula]

I have a table called password. it has three fields, the username, password
and accesslevel.I also have a form that is used as access control screen for
authenticating the users who have been defined in this password table. the
form works perfectly, however i need to add one more feature to this. I want
the passwords to be expiring every two weeks and cosequently blocking all
expired passwords. I need a module that will allow me to do this. I will
appreciate a sample of code.

Wantula

 

[Lynn Trapp]

You could add one more field to your table -- PasswordExpireDate -- and
check that date when you validate your users. If the current date is >= to
PasswordExpireDate, then prompt the user to change the password.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html