Hi Jean-François
As Doug says, this is not built it to Access, but you could have your own
table of users and password change dates, and build your own form for users
to change their password.
The actual code to change a password is quite simple:
DBEngine(0).Users(CurrentUser).NewPassword sOldPwd, sNewPwd
You just need to add error trapping, and a check when the database opens
that it's not time for a change.
--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
Jean-Francois Bouthillier said:
Hi all,
I am using Access 2002 workgroup file for security. How
can I give users a flag when it has been more than x days
since they last changed their passsword?
Thank you very much,
Jean-Francois