Button Security

Topic

New Reply

I have a button on a form that opens up another form within the same database. Would like to know how I can make this button secure with a password. Want to see when user clicks on this button a message box apperar requesting password id before allowing user to enter the associated form. If password is incorrect then a message box will appear saying so. Thanks in advance for your time and help

Reply | Quote

Replies

If you’re using Access security, you could simply assign permissions to the second form for particular users or groups, so no password would be needed. Alternatively, with security in place, you could check the user group the user was in and hide the button altogether if the user doesn’t have permission to see it.

Reply | Quote

I have security implemented on my database – how do you set the permissions for the particular button?

Reply | Quote

You don’t. What you do is check the user in the open event of the form to see if he has permission to see the button. If he belongs in the group you want to allow access to the button, make it visible, otherwise don’t.

Reply | Quote

http://www.DataBaseCreations.com has security tools to take security to the control level.

HTH John Graves

Reply | Quote

I have used this code many times.
Private Sub close1_Click()
On Error GoTo Err_close1_Click
Dim stDocName As String
Dim stLinkCriteria As String

If InputBox(“Enter Password for Directory Maintenance”, “Confirm Delete”) = “YOURPASSWORD” Then
‘stdocname is the form to open after the PW is entered
stDocName = “frmDateTime”
DoCmd.close
DoCmd.OpenForm stDocName, , , stLinkCriteria

End If

Exit_close1_Click:
Exit Sub

Err_close1_Click:
MsgBox Err.Description
Resume Exit_close1_Click

End Sub

Reply | Quote

What about using the CUrrent User function like :

If CurrentUser = “Joe Bloggs” then
btnButton.enabled =false
End if

?

Reply | Quote

This is OK

What happens when users leave and new users start using the system? How many hardcoded objects have to be changed? Could be a maintenance nightmare.

With the following code, its all done once in one place by the system administrator

http://www.DataBaseCreations.com has security tools to take security to the control level.

HTH John Graves

Reply | Quote