Setting a Password

[exm206]

I have an application where the user must go through a switchboard to get to each individual form or table. Many people on the network have access to this database and all its forms and tables. I want to set one specific button on the switchboard so only two specific people can access it. In other words, I only want two specific people to be able to press the button for the Payroll info and have the information come up. Is this possible using a password or maybe somehow only granting access to specific network usernames? Any help or advice is greatly appreciated. Thanks,
Eric

 

[Dugantrain]

Well, the cheapest way would be just to write some code behind the button:

Your_Button_On_Click()
If InputBox("Enter A Password")<> "Let Me In, Jackass" Then
Msgbox "Incorrect Password!"
Exit Sub
Else
Docmd.OpenForm, blah blah blah
End If
End Sub

And then just give the two users the correct password. Now, of course, if your database is an .mdb file, then anyone can look at your VBA code to determine the correct password. Like I said, it's the cheapest and not necessarily the best way, but I'm fortunate enough to work in a department where ignorance has been my prime security feature. Search the Forums of
http://www.access-programmers.co.uk/forums/
for a more robust solution, including grabbing the Users' Windows Login information.