Use of Pass words w Switchboard

[Nan]

Is it possible to secure database access at the switchboard level. Meaning
that the different or multiple options on the main switchboard can be
accessed only after being prompted and supplying a specific password? For
example on my main swithboard I have created the option buttons of:

New Employee Data
Admin
Exit

I would like to password protect the option for Admin by placing a prompt
after Admin has been selected requesting a password. Is this possible? Thank
you!

 

[akphidelt]

Yes there is,

One way of doing this is to create a password form that popups up. And this
form will not open the next form until the proper password is used.

You will have to use VBA to validate the password though.

Something like

If Me.textbox = "YourPassword" Then

DoCmd.OpenForm "YourForm"

Else

MsgBox "You have inserted an incorrect password"

End If

There are other ways of doing this with input boxes and such but setting up
a form is the easiest for me.

 

[Wayne-I-M]

Static Counter As Integer
If txtPassword = "Your Password" Then
DoCmd.OpenForm "Form Name", acNormal, "", "", , acNormal
DoCmd.Close acForm, "frmPassword"
Else
If Counter < 2 Then
MsgBox "The password you entered is not correct - try again - MAX 3
ATTEMPTS?", vbOKOnly, "Form Entry Declined"
Counter = Counter + 1
txtPassword = ""
Else
DoCmd.Quit
End If
End If

 

[Wayne-I-M]

Also

Disable to Shift/Enter option - or the password is usless