Randanmization of tables if password is lost
Posted on 2006-05-31
I currently have a function that sends an e-mail to users in my db with randomize mixed 8 character numeric / text password replacement if users pasword is lost or forgotten.
I will like to experiment a new method when a button is clicked to generate and send a new randomized decrypted password to the current user and also updates tblSecurity.Password; tblPasswords_old.Passwords_old with the encrypted new password in addition to calling SavePassword(strUser, PerformEncryption(Me.Password, True), dtmModified).
I dont know if this is achievable - this is only an experimentation and would have nothing to lose if it doesnt work.