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
<N**@discussions.microsoft.com> wrote:

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


Show quoteHide quote

How to protect Access application from Reverse Engineering
Problems adding hyperlinks to forms
Probs accessing database for users of newly developed Superuser gr
New virus "brastk.exe"
Re: Access 03 Security
you do not have permissions...
I've locked myself out of design mode
need to add permission to a db
Creating user login
set database password when converting AC00 to AC07