Types of 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.
The following table summarizes the permissions that you can assign.
| Permission | Permits a user to | Applies to |
|---|---|---|
| Open/Run | Open a database, form, or report, or run a macro. | Databases, forms, reports, and macros |
| Open Exclusive | Open a database with exclusive access. | Databases |
| Read Design | View objects in Design view | Tables, queries, forms, reports, and macros |
| Modify Design | View and change the design of objects, or delete them. | Tables, queries, forms, reports, and macros |
| Administer | For databases, set database password, replicate a database, and change startup properties. For tables, queries, forms, reports, and macros, have full access to these objects and data, including ability to assign permissions. |
Databases, tables, queries, forms, reports, and macros |
| Read Data | View data. | Tables and queries |
| Update Data | View and modify but not insert or delete data. | Tables and queries |
| Insert Data | View and insert but not modify or delete data. | Tables and queries |
| Delete Data | View and delete but not modify or insert data. | Tables and queries |
Note
Some permissions automatically imply the selection of others. For example, the Update Data permission for a table automatically implies the Read Data and Read Design permissions because you need these to modify the data in a table. Modify Design and Read Data imply Read Design. For macros, Read Design implies Open/Run.
To design forms, reports, macros, modules in a multiuser environment, you must open a Microsoft Access database exclusively, which means you must have Open Exclusive permission on the Access database. Learn about saving design changes to a shared Access database.
In general, for users to access a linked table, grant Read Data and Read Design permissions on the table in the back-end database, and Modify Design permission on the table link defined in the front-end database so that users can conveniently re-link the table. If you want to restrict all access to the back-end table but still allow users to view the data and re-link the tables, remove all permissions on the back-end table and use queries in the front-end database with their RunPermissions property set to Owner's.