DEFAULT PERMISSIONS FOR NEW QUERY

Change Default Permissions

You can change the default permissions that allow others to view data returned from queries or in the case of action queries, to run the queries, even if they are otherwise restricted from viewing the underlying table or query.

Changing the default permissions affects only new queries.

1. On the Tools menu, click Options
2. Click the Table/Queries tab.
3. Click the Run Permissions option you want to use.

If you select Owner's:, 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.

If you select User's, the permissions that are defined for that classification of users are in effect instead and any user with Administer permissions for the query can save changes to the query, or change its ownership.

Click Next to see how to set Run Permissions Property of Queries.

Goto Main

<-- For FB Posts without Images<-- For FB Posts without Images

Earlier Post Link References:

-->

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×