User Change Own Password

[spaceherpe61]

I have user security on an Access DB that I created. I also diabled all menus and shortcuts, because I don't want the users getting in and changing what they are not allowed to change. My question is there a way code a Change password function on a form, or allow that menu to show up without giving them access to everything else.

 

[mp9]

If you add the "User and Group Accounts" menu option to a custom menu of your own, provided you have got appropriate user-level security set up (i.e. the users don't have the privileges to administer accounts) then the only options that wil be enabled to the user will the those for changing their own password - the others will be greyed out.

Alternatively, you can code a bespoke solution using the NewPassword method - if you search Access' VB help for NewPassword you'll find a crude example that you can adapt for your own purposes, perhaps by building it into a form with a couple of text boxes formatted as Password (so they display asterisks when typed in) and so on.

Hope this helps.

http://www22.brinkster.com/accessory/