Password protect a switchboard button on the main switchboard Access 2003

[amanda27]

Is there anyway to password protect a switchboard button the main switchboard so they can not get to the swtichboard it goes to or any of it's options?
Please help
I have been trying code I found on the internet but it does not seem to be working.
Thanks

[Rabbit]

So... basically you want to password protect some of the options on the main form?

[amanda27]

I want to protect one button on the mainform that goes to another switchboard with other options. Pretty much it's like the Admin Menu which only one person should have access too.

So... basically you want to password protect some of the options on the main form?

[Rabbit]

Do you have other security measures in place? Or will this be the only security measure you need?

[amanda27]

This is the only one I will need.

Do you have other security measures in place? Or will this be the only security measure you need?

[Rabbit]

You'll want to create a mediating form that has a textbox for them to enter a password. Then code will run, possibly on the click of a button that checks this password.

This is unsecure until you convert it to an mde.

Another route is to use the mdw security system built into Access that requires them to log in to access the database. Through code, the form will then only allow them to use the button if they are a member of the Admins group.

[amanda27]

Do you know what the code is that I would use? I am not very good in the coding department.

You'll want to create a mediating form that has a textbox for them to enter a password. Then code will run, possibly on the click of a button that checks this password.

This is unsecure until you convert it to an mde.

Another route is to use the mdw security system built into Access that requires them to log in to access the database. Through code, the form will then only allow them to use the button if they are a member of the Admins group.

[Rabbit]

Well basically if you have a textbox called txtPassword and a button called butSubmit:

Private Sub butSubmit_Click()
   If Me.txtPassword = "Some Password" Then
      ' Password is correct, continue.
   Else
      MsgBox "Login Failed", vbOkOnly
      ' Password is incorrect, do not continue.
   End If
End Sub

[Hexadane]

Hi ok i also just want to password protect a button on the switchboard as i will be th only one adding and deleting data

[ADezii]

Is there anyway to password protect a switchboard button the main switchboard so they can not get to the swtichboard it goes to or any of it's options?
Please help
I have been trying code I found on the internet but it does not seem to be working.
Thanks

Because the Switchboard is basically a single Form that is dynamically created and modified, it would be very difficult to accomplish what you are requesting. It would, however, be a relatively simple task to bring up an Intermediate Password Entry Form that would prompt the User for a User Name/Password combination and then proceed accordingly. Basically, a Switchboard Button would call a Public Function that would provide this functionality.