Query Passwords

  • Thread starter Thread starter steve12173
  • Start date Start date
S

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.
 
steve12173 said:
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.
Click to expand...

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
 
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
 
steve12173 said:
I
have a database with financial information that a select group of people
have
access.
Click to expand...

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

Keith.
 
Back
Top