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" wrote: > 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
On Mon, 25 Aug 2008 08:50:01 -0700, steve12173 wrote: 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 >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" wrote in message news:F82F013A-0450-4ADB-A819-B16F252CE098@microsoft.com... > 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.
