Hi,
I have an access database setup which I have the need to secure one of the
choices from the swithboard. I would like to use a password so that only
certain people can update this choice.

Your help would be appreaciated.


Thanks,
Ted

You can't do it on the switchboard, just do it on the form or report that
the switchboard calls.

Personally, I don't secure individual objects with passwords. It is not
very secure, and I don't want password prompts popping up everytime an
important feature is used. This means your most important users are the
most inconvenienced.

A better option is to implement user-level security. Have each user sing on
one time when they open the file and then their access is set for every
object and function in the file. They will only be able to do what you have
given them permission to do.


--
Rick B



"Misterted" <(E-Mail Removed)> wrote in message
news:3FD9F5E1-DAF2-478D-A318-(E-Mail Removed)...
> Hi,
> I have an access database setup which I have the need to secure one of the
> choices from the swithboard. I would like to use a password so that only
> certain people can update this choice.
>
> Your help would be appreaciated.
>
>
> Thanks,
> Ted

Thanks for you quick response Rick. Could you give me more detail on how to
protect the form?

"Rick B" wrote:

> You can't do it on the switchboard, just do it on the form or report that
> the switchboard calls.
>
> Personally, I don't secure individual objects with passwords. It is not
> very secure, and I don't want password prompts popping up everytime an
> important feature is used. This means your most important users are the
> most inconvenienced.
>
> A better option is to implement user-level security. Have each user sing on
> one time when they open the file and then their access is set for every
> object and function in the file. They will only be able to do what you have
> given them permission to do.
>
>
> --
> Rick B
>
>
>
> "Misterted" <(E-Mail Removed)> wrote in message
> news:3FD9F5E1-DAF2-478D-A318-(E-Mail Removed)...
> > Hi,
> > I have an access database setup which I have the need to secure one of the
> > choices from the swithboard. I would like to use a password so that only
> > certain people can update this choice.
> >
> > Your help would be appreaciated.
> >
> >
> > Thanks,
> > Ted
>
>
>

I think there are instructions in the security FAQ if you want code to
simply protect one form. Again, this is not a very good solution. Folks
could easily juat open the table or the query and make changes there,
bypassing your form.



--
Rick B



"Misterted" <(E-Mail Removed)> wrote in message
news:79D59286-54EC-4DC0-B774-(E-Mail Removed)...
> Thanks for you quick response Rick. Could you give me more detail on how
to
> protect the form?
>
> "Rick B" wrote:
>
> > You can't do it on the switchboard, just do it on the form or report
that
> > the switchboard calls.
> >
> > Personally, I don't secure individual objects with passwords. It is not
> > very secure, and I don't want password prompts popping up everytime an
> > important feature is used. This means your most important users are the
> > most inconvenienced.
> >
> > A better option is to implement user-level security. Have each user
sing on
> > one time when they open the file and then their access is set for every
> > object and function in the file. They will only be able to do what you
have
> > given them permission to do.
> >
> >
> > --
> > Rick B
> >
> >
> >
> > "Misterted" <(E-Mail Removed)> wrote in message
> > news:3FD9F5E1-DAF2-478D-A318-(E-Mail Removed)...
> > > Hi,
> > > I have an access database setup which I have the need to secure one of
the
> > > choices from the swithboard. I would like to use a password so that
only
> > > certain people can update this choice.
> > >
> > > Your help would be appreaciated.
> > >
> > >
> > > Thanks,
> > > Ted
> >
> >
> >

Thanks Rick.

"Rick B" wrote:

> I think there are instructions in the security FAQ if you want code to
> simply protect one form. Again, this is not a very good solution. Folks
> could easily juat open the table or the query and make changes there,
> bypassing your form.
>
>
>
> --
> Rick B
>
>
>
> "Misterted" <(E-Mail Removed)> wrote in message
> news:79D59286-54EC-4DC0-B774-(E-Mail Removed)...
> > Thanks for you quick response Rick. Could you give me more detail on how
> to
> > protect the form?
> >
> > "Rick B" wrote:
> >
> > > You can't do it on the switchboard, just do it on the form or report
> that
> > > the switchboard calls.
> > >
> > > Personally, I don't secure individual objects with passwords. It is not
> > > very secure, and I don't want password prompts popping up everytime an
> > > important feature is used. This means your most important users are the
> > > most inconvenienced.
> > >
> > > A better option is to implement user-level security. Have each user
> sing on
> > > one time when they open the file and then their access is set for every
> > > object and function in the file. They will only be able to do what you
> have
> > > given them permission to do.
> > >
> > >
> > > --
> > > Rick B
> > >
> > >
> > >
> > > "Misterted" <(E-Mail Removed)> wrote in message
> > > news:3FD9F5E1-DAF2-478D-A318-(E-Mail Removed)...
> > > > Hi,
> > > > I have an access database setup which I have the need to secure one of
> the
> > > > choices from the swithboard. I would like to use a password so that
> only
> > > > certain people can update this choice.
> > > >
> > > > Your help would be appreaciated.
> > > >
> > > >
> > > > Thanks,
> > > > Ted
> > >
> > >
> > >
>
>
>