Re: Switchboard behind password

From: Al (Al_at_discussions.microsoft.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 11:29:04 -0800

In this particular case password is not intended for a large group of people
or "high security" reasons (maybe not even security reasons at all). Is just
to avoid looking info certain user does not want to see.

If I understand the idea, it would be enough to make a new form
(copy-pasting from the switchboard) in which I can put 2 buttons with a code
included in the "open" event in every one of them, and that takes me either
to my "user1_options" or "user2_options" switchboard, ?

In the case that this is correct, I have to input a password EVERY single
time I open another form?, or it just sticks with the first "jump" between my
new form and the "userX_options" switchboard?

Besides, is it possible to make this new hand made form the default after
the splash screen ?

Thanx in advance Rick !

"Rick B" wrote:

> I doubt you can do it on your switchboard. If you create your own form that
> looks like a switchboard, then you can put code in the "open" event to
> require a password. Personally, I think that is a very very bad idea. I
> prefer to set up user-level security and then control access to objet based
> on the login.
>
> If I were and administrator, I would not want to have to type in passwords
> all over the place while working in my database. I'd prefer to type in a
> user id and password once when I open the file, and know that I could get to
> anything to which I had access. It would also be nice to know that others
> could not get into anything they shouldn't.
>
> If you want to password protect a form, there are plenty of posts out there
> on how to do it. Just do a search on previous messages and you should find
> some.
>
> Rick B
>
>
> "Al" <Al@discussions.microsoft.com> wrote in message
> news:4D6ED6A9-9563-4A7D-8951-4AB2AB6F68CB@microsoft.com...
> > Being a brand new user of Access (A-2000)and a real noob on VB, I'm having
> > the worst of my time trying to make a "special menu" using switchboard
> > manager. I've figured out everything I want my db to do, but still haven't
> > been able to put 2 buttons on the first (of 3) switchboard in which the
> user
> > would pick either of them and ask him to input a password to redirect him
> to
> > the next "protected" switchboard.
> >
> > Objective.- To have a switchboard that will enable a user to access an
> > "admin switchboard" through a password.
> >
> > I've seen the code of the switchboard form,and even seen some codes online
> > on how to make a button (any button) ask for a password, but the way the
> > manager arranges the switchboard form (creating a table) makes it
> impossible
> > (to me) to get that "online aquired code" IN my switchboard manager made
> > form...
>
>
>