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 wouldn't 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 sets the RunPermissions property to specify the owner's permissions, you can run an append query to add records to a table.
Setting
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 by using the query's 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.