Query Passwords

[steve12173]

Is there a way to set that a password be given to run a specific query. I
have a database with financial information that a select group of people have
access. But I only want a couple people to have access to one specific query.

 

[Chris O''Neill]

Is there a way to set that a password be given to run a specific query. I
have a database with financial information that a select group of people have
access. But I only want a couple people to have access to one specific query.

I'm no expert, so maybe one of the MVP's will have a better idea, but I
think the easiest way to do this would be to create another group that only
has privileges to the query (and tables/forms that it relies up) and nothing
else, and then assign the select group of people to that group. Anybody else
who tries to access the query will be out of luck. (Btw, don't forget to
make sure that no other users/groups (except the system
administrator/developer has any privileges for the query.)

Hope that helps...

Regards, Chris

 

[Tom van Stiphout]

On Mon, 25 Aug 2008 08:50:01 -0700, steve12173

Are you already using Access' workgroup security?
If not, what kind of security do you currently have in the app?
What version of Access?

-Tom.
Microsoft Access MVP

 

[Keith Wilby]

I
have a database with financial information that a select group of people
have
access.

You do realise that Access is not an appropriate platform for sensitive
data?

Keith.