Hi,

I know it is possible to password protect an entire database however is it
possible to apply password protection on individual command buttons on a
switchboard. I have one form I wish to restrict access to.

Thanks,
David

See these knowledge base articles:
http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

Show quoteHide quote

Try this it works on mine for a button. In the event/on click put this code in.

Private Sub The name of your button_Click()

Dim strPasswd

strPasswd = InputBox("Please Enter Password", "Restricted Form")

'See if a valid entry made to input box

If strPasswd = "" Or strPasswd = Empty Then
MsgBox "No Input Provided", vbInformation, "Required Data"
Exit Sub
End If

'correct password is entered open Main form Close, Opening Sheet

If strPasswd = "enter your password here" Then
DoCmd.OpenForm "Enter your form name you want open here", acNormal
Else
MsgBox "Sorry, you do not have access to this form", vbOKOnly, "Important
Information"
Exit Sub
End If
End Sub

Show quoteHide quote

Replication and security
How do I assign a digital signature to an MDB on our network?
using the opencurrentdatabase in script
Mdw file not found
No exclusive access
Need Help To Create a MDE with certain Items Available
how do i unlock my document
secured database can be opened
Access 2003 hyperlink security warning every time
Securing the back end of the database