Access 2000 Create your own password

[Guest]

I have a secure database and I would like to allow users to assign / change
there own password. It looks like I have to allow them to use Full Menus to
do this. Problem is, they can do and see to much with full menus. How can I
set it up so they have restricted menus yet create / change passwords

 

[Joan Wild]

You can create your own form for the users to change their password.

At its simplest: an unbound form with three
textboxes txtUsername, txtPwd, txtConfirmPwd
Add a button with the following in its click event

DbEngine.Workspaces(0).Users(Me!txtUsername).NewPassword Me!txtPwd,
Me!txtConfirmPwd

Look in Help for more details. There is likely code in the security FAQ as
well.
http://support.microsoft.com/?id=207793

 

['69 Camaro]

Hi.

It looks like I have to allow them to use Full Menus to
do this.

No, you don't. The easiest way to allow the user to change his own password
is by putting a button on a form, place [Event Procedure] in the button's
OnClick( ) event, and paste this code in the form's module, ensuring the
name of the button matches what is currently ChgUsersPswdBtn in this
example, then save and compile the code.

Private Sub ChgUsersPswdBtn_Click()

On Error GoTo ErrHandler

SendKeys "^+{TAB}", False
RunCommand acCmdUserAndGroupAccounts

Exit Sub

ErrHandler:

MsgBox "Error in ChgUsersPswdBtn_Click( ) in" & vbCrLf & _
Me.Name & " form." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear

End Sub ' ChgUsersPswdBtn_Click( )

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.