Password protect button on a switchboard 1

[gotnomoney]

I am a new Access user, I was wondering if and how you could password protect a button on a switchboard item. I have forms that should only be accessed by certain people and some that can be accessed by all. Any help would be great. Thanks!!!

 

[psemianonymous]

If you are comfortable with VBA, then here you go:

on the click event:



If InputBox(&quot;Enter password for this feature:&quot <> &quot;myspecialpassword&quot; Then
Exit Sub
End If

'the rest of the code goes here


This is easily breakable, but will keep you casual &quot;accidental&quot; intruders out of the form. I've written an (overly) detailed FAQ about the subject of bad but acceptable security: faq181-3893

 

[gotnomoney]

Thank you so much for all the help.