User-Security for an item in a database?

[Guest]

Does anyone know if it is at all possible to place password protection on
only a piece of the database? What I am trying to do is allow everyone to
open the database but when a specific button is pressed, only a handful of
people are allowed access to it. Is this possible?

Please advise.

 

[Brian Smith]

Does anyone know if it is at all possible to place password protection on
only a piece of the database? What I am trying to do is allow everyone to
open the database but when a specific button is pressed, only a handful of
people are allowed access to it. Is this possible?

Please advise.

Do you mean you only want certain people to be able to access a given form
and its underlying data when they click on a button? If that is the case
then yes it is possible. Read the Security FAQ many times over and follow
the steps exactly. Also ask a lot of questions in the NG. There are a lot of
very helpful people here. That's what I did and if you work away you'll get
things to work out.

To get you on the right track don't think about giving individual users
certain permissions. Assign permissions based on groups and place people
into the correct groups. It's much easier to move people in and out of
groups than it is to keep track of individual permissions. Also, users can
belong to more than one group.

Good luck.

Brian

 

[Guest]

Thanks for the reply, I think i'm probably a little dense though, which
Security FAQ are you refering to?