Query.
You can use the RunPermissions property in a multiuser environment with a secure workgroup to override the existing user permissions. This allows you to view a query or run an append, delete, make-table, or update query that you otherwise would not have permission to run. For example, as a user, you may have read-only permission for queries, while the owner of the queries has read/write permission. If the owner set the RunPermissions property to specify the owner’s permissions, you can run an append query to add records to a table.
Note The RunPermissions property applies only to append, crosstab, delete, make-table, select, and update queries.
The RunPermissions property uses the following settings.
|
Setting |
Description |
|
Owner’s |
All users are allowed the owner’s permissions to view or run the query. |
|
User’s |
(Default) Users have only their own permissions to view or run the query. |
You can set this property using the query property sheet.
You can also set the RunPermissions property in SQL view of the Query window by using the WITH OWNERACCESS OPTION declaration in the SQL statement.
The following example is a select query based on the Categories table that enables all users to have the owner’s permissions for the query.
SELECT DISTINCTROW Categories.[CategoryID], _
Categories.[CategoryName], Categories.DescriptionCategories OWNERACCESS OPTION;