Password Protection

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

 

[Tom van Stiphout]

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