how can i secure a choice on a switchboard in access?

[Misterted]

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

 

[Rick B]

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.

 

[Misterted]

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

 

[Rick B]

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.

 

[Misterted]

Thanks Rick.

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.