username passwords

[yourdeployedson]

I would like to add a command button that would allow the current user to change his/her own password. Their passwords are currently locked within the database system features. AKA:

Tools--Security--User/Group Accounts

Is it even possible to allow them to change their password or do I need to set up my own table and login form to allow the change. If so, I'm at a loss on how to accomplish this.

 

[yourdeployedson]

sry, this is an Access database. I forgot to relay that

 

[JerryKlmns]

Cnn.Execute "Alter User " & TheUser & " Password " & ThePswrd & " " & TheNewPswrd

Cnn is an open connection to your datebase
TheUser is the userID for Access whose password is to change
ThePswrd is the current password to change
TheNewPswrd is the new password

You should better post Access questions in dedicated Access fora. For this case forum705