faq702-4282 has been posted in the Microsoft Access: Forms forum. It shows how to build a Change Password form you can import into any application to let users change their Access logon passwords.
The form is usable with Access user-level security only. It's useless for "security" implemented in VBA code.
The form also lets members of the Admins group change other users' passwords. This is more secure than the built-in "clear password" function in the Access user interface.
This form adds no security risk to your application. It doesn't modify or circumvent or expose to change any permissions you've created. Even if a user "broke into" the form and modified the code, he could not expand his permissions and make unauthorized changes to other people's passwords.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
The form is usable with Access user-level security only. It's useless for "security" implemented in VBA code.
The form also lets members of the Admins group change other users' passwords. This is more secure than the built-in "clear password" function in the Access user interface.
This form adds no security risk to your application. It doesn't modify or circumvent or expose to change any permissions you've created. Even if a user "broke into" the form and modified the code, he could not expand his permissions and make unauthorized changes to other people's passwords.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein