How to force a password change on first login in vba

[Midzie]

Hi Everyone,

I have a code that auto generate a password for the newly created user. How do I make my small application to implement a force password change on first login without setting a default password. I don't use a default password because every newly created user has different auto generated password. Please advise, thank you very much in advance!

[NeoPa]

Design the table that stores the user info (including the password) to include a flag field also, that indicates whether a password has been activated or not.