How to make an user password expires after 90 days (1 Viewer)

[musmoniem]

I had a access database i made table with usernames & passwords of users .. and i need to make these passwords expires after 90 days ... any help please

 

[June7]

Have a field with date password last changed. Have code when user logs in to calculate elapsed days.

 

[musmoniem]

Have a field with date password last changed. Have code when user logs in to calculate elapsed days.

How to do this ??

 

[June7]

After user provides valid credentials, do a lookup on the DateChange field and calculate if 90 days have passed. If so then require user to provide a new password. Open a form bound to Users and open to this user's record. They enter new password. Code sets value of DateChange field.

Me!DateChange = Date()

The code will likely get quite complex so when you have specific issue, post question.