If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Switchboard passwords
I have two switchboard pages. One with options for a user and one with
options for an admin. On the main switchboard I have two selections: user and admin. I want to be able to attach a password to the admin selection so that when someone clicks it they will be prompted for a password and then directed to the admin switchboard. |
#2
|
|||
|
|||
Switchboard passwords
Do you have user level security enabled? If not, don't even bother the the
Switchboard password. Why? With the database open, press the F11 key. Everyone can get at anything. You can disable special keys like F11; however, even that can be bypassed unless you implement user-level-security. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Lisa" wrote: I have two switchboard pages. One with options for a user and one with options for an admin. On the main switchboard I have two selections: user and admin. I want to be able to attach a password to the admin selection so that when someone clicks it they will be prompted for a password and then directed to the admin switchboard. |
#3
|
|||
|
|||
Switchboard passwords
On Wed, 10 Mar 2010 12:19:01 -0800, Lisa
wrote: I have two switchboard pages. One with options for a user and one with options for an admin. On the main switchboard I have two selections: user and admin. I want to be able to attach a password to the admin selection so that when someone clicks it they will be prompted for a password and then directed to the admin switchboard. As Jerry says, you may find it difficult to keep snoopy people out: "locks keep out honest folks". If someone seriously wants to bypass your security and has a modicum of knowledge about Access they'll be able to crack it, or find someone who can. That said, for a $9.95 three-digit combination bicycle lock equivalent, you can put code in the Click event of the command button that opens the admin form: Private Sub cmdOpenAdmin_Click() Dim strPwd As String strPwd = InputBox("Enter administrative password:", "Password Check") If strPwd = "Open Sesame" Then DoCmd.OpenForm "adminformname" Else MsgBox "Incorrect password" End If End Sub You can make it much more elaborate, with three retries, etc. if you wish. If the user has a MDE file they won't (easily) be able to see the Open Sesame or whatever password you choose, but as I say, this is very lightweight security. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|