Password Protection

  • Thread starter Thread starter Nan
  • Start date Start date
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!
 
On Mon, 20 Oct 2008 11:04:10 -0700, Nan

There is nothing built-in that can do that, but that doesn't have to
stop you.
I am assuming your switchboard option is opening an Admin form. In
that form's Form_Open event write this one-liner:
Cancel = (InputBox("Give password") <> "secret")

There are of course much more sophistic ways of dealing with security
(personally I would check membership of a security group in Active
Directory), but this may be good enough for your purposes.

-Tom.
Microsoft Access MVP
 
Back
Top