Update Password

[SueBK]

I have a command button with a password. I lifted the code straight from a message I found on the forum here. I assume it is possible to allow the user to update the password somehow, without introducing them to the finer art of VB programming. How would I do that?

Code I'm using is:

Private Sub Command30_Click()
  If InputBox("Please enter password to continue", "Password Input") <> "aaa" Then
    MsgBox "Wrong password entered.  Operation aborted", vbCritical
  Else
    Me.ChooseRpt_Label.Visible = True
Me.Combo37.Visible = True
Me.ChooseRpt.Visible = True
End If
End Sub

 

[DCrake]

You will need to maintain a tble of users and passwords. The use of the Input Box does not mask/hide the password as it is typed in so anyone looking can the password.

Here is a link to a demo I put together that uses a global password but will give you a starter.

http://www.access-programmers.co.uk/forums/showthread.php?t=170781

David