Permit others to view or run my query but not change data or query design

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

In a secure workgroup, you can assign others permission to view the data your query returns or, in the case of an action query, to run the query, even if they are otherwise restricted from viewing the query's underlying table or query.

1. Open the query in Design view.

2. Select the query by clicking anywhere in query Design view outside the design grid and the field lists.

3. Click Properties aa170900(v=office.10).md on the toolbar to display the query's property sheet.

4. Set the RunPermissions property to Owner's.

   The following are true for this setting:

   • All users have the query owner's permission to view or run the query.

   • Only the query owner can save changes to the query.

   • Only the query owner can change the ownership of the query.

Note   You can also set default permissions for all new queries. Click Options on the Tools menu. Click the Tables/Queries tab, and then click the Run Permissions option you want to use.