Workgroup Security - Change Password of User 1

[dar149]

I have set up Workgroup Security on an Access 2000 Database. I had to give each user a logon ID and Password, since they can only view their own reports. Now some of the users want to change their password. I haven't been able to find a way to change their password. I can only find a way to change the Admin password. Any ideas?

 

[RickSpr]

If your application's menu includes the Tools>Security>User and Group Accounts menu item, they can use that to change their password.

Unfortunately, the User and Group Accounts dialog also contains items that may be irrelevant or confusing to them, so you might not want to give them access to it. What you can do instead is to create your own small form that prompts for the current and new passwords.

I wrote a FAQ describing a form that will do this. It's in the Microsoft: Access Forms forum, but you can follow this link: faq702-4282.

(New FAQs are subject to approval, so it may not appear for a day or so.)

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[dar149]

Thanks! The form is a great solution. If the users forget their password, can I just clear it in the User Group and Accounts window, then let them use the form to enter a new password?

 

[RickSpr]

Yup! The FAQ form does exactly the same thing as the Change Logon Password page of the dialog, so it blends right in with all the built-in Access security gizmos.

You know, you made me realize that the form could pretty easily be enhanced so that security administrators could use it to change other people's passwords. One disadvantage of the built-in dialog is that you can clear a user's password, but you can't set it. So there's a period of time when that user account isn't secure at all. In big shops, real security administrators assign real passwords, and let the user change them right away, but they never leave an account unprotected even briefly. I think I'll enhance the form so you can assign passwords for other people, if you're a security administrator.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[dar149]

Great! I'll keep checking to see when the form is updated. Thanks for all your help.

 

[RickSpr]

faq702-4282 has now been updated to allow members of the Admins group to change any user's password.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[AKMonkeyboy]

Excellent FAQ Rick - any chance you have similar code to allow someone to ADD a user without going through the Tools >S ecurity > ...?

This might be complex because of viewing permissions - but thought I'd ask.

Thanks again for the good FAQ!

Adam