Use of Pass words w Switchboard

N

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!
 
A

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.
 
W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top