vba code for password expire 30 days in microsoft access form

[lacampeona]

hello

maybe somebody know how to make that password in my login form can expire every 30 days for my users?

i have a login form for my users and now i want that every 30 days they have to change their password.

maybe somebody can suggest how to do that? or maybe where i can study that?

thank you

 

[Gasman]

hello

maybe somebody know how to make that password in my login form can expire every 30 days for my users?

i have a login form for my users and now i want that every 30 days they have to change their password.

maybe somebody can suggest how to do that? or maybe where i can study that?

thank you

Put a date in the table that the password was last changed and compare current data against that?

 

[lacampeona]

hello

yes me also was thinking about that
but what i have to do now?

I have to write some code no?
if ... ... ≤ 30 .... something like that no?

 

[Gasman]

It would be something along the lines of

If Date >= PasswordDate + 30 then
   DoCmd.OpenForm "frmPassword", , , "UserID=" & Me.UserID
End If

where frmPassword is your form for allowing the change of the password, and Me.UserID is the PK you obtained to look at the users password.

https://msdn.microsoft.com/en-us/library/office/ff820845.aspx?f=255&MSPPError=-2147217396

The form would likely be a popup/modal.

HTH

 

[lacampeona]

hello

thank you for advise. i will try to do that.