Access Permission

[danny123]

Hi there

Can i set permission on a single button in a access database form for specific number of users. And rest of the database is available for everybody ?

Thanks
Danny

 

[jfgambit]

You can apply a password to the buttons OnClick event

If InputBox("What is password?", "Password Protected") = "scooby" Then
    DoCmd.OpenQuery "Nameofyourquesry", acViewNormal
Else
    MsgBox("Incorrect password", vbOKOnly, "Invalid password") = vbOK
End If

 

[boblarson]

Or you can do something like what I did in this post. See my sample I posted. It's not exactly the same, but you should be able to modify to fit your needs.
http://www.access-programmers.co.uk/forums/showthread.php?t=119702