Prompting to change user passwords 1

[LDG1234]

Can anyone tell me a way to prompt the user every 30 days to change their password? I will be writing my own security rather than using the standard access one.

Thanks Lloyd Gozzett
Process Developer

 

[Nebuchednezzar]

Well, if you are going to be storing user passwords in a table, just add a column to that table to store the date last changed (when a user changes their password, update the table with the current date (now function).

Then, when they login each time, check the login table for the date...if it is older than 30 days old, prompt for change.

 

[LDG1234]

Thanks - I'll give that a go. Lloyd Gozzett
Process Developer