Work with permissions

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.

What do you want to do?

Learn how permissions work and who can assign them

Learn about types of permissions

Assign or remove permissions for a database and existing tables, queries, forms, reports, and macros

Assign default permissions for new tables, queries, forms, reports, and macros

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

Change default permissions of all new queries

Learn more about the RunPermissions property