RUN PERMISSIONS PROPERTY

RunPermissions Property

You can use the RunPermissions property in a multi-user 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 will be able to run. For example, as a user, you have read-only permission for queries, while the owner of the queries has read/write permissions. 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:

1. Setting Description
2. Owner's: All users are allowed the owner's permissions to view or run the query.
3. 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 the SQL view of the Query window by using the WITH OWNERACCESS OPTION declaration in the SQL statement.

<-- For FB Posts without Images

Earlier Post Link References:

-->

MS-ACCESS Security Links.

1. Create a security user account
2. Create a security group account
3. Add users to security groups
4. Remove users from security groups
5. Delete a security user account
6. Delete a security group account
7. Create or change a security account password
8. Clear a security account password
9. Assign or remove permissions
10. Assign default permissions for new tables, queries, forms, reports, and macros.
11. View or transfer ownership of Objects
12. Transfer ownership of an entire database to another administrator
13. Permit others to view or run my query but not change data or query design.
14. Change default permissions for all new queries.
15. RunPermissions Property
16. Convert Microsoft Access 95 or 97 secured databases.
17. Convert a workgroup information file from a previous version of Microsoft Access.
18. Share a previous-version secured database across several versions of Microsoft Access

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in Ginger×