Note The information in this topic applies only to a Microsoft Access database (.mdb).
The following table summarizes the permissions (permissions: A set of attributes that specifies what kind of access a user has to data or objects in a database.) that you can assign.
||Permits a user to
||Open a database, form, or report, or run a macro (macro: An action or set of actions that you can use to automate tasks.) in a database.
||Open a database with exclusive (exclusive: A mode of access to data in a database that is shared over a network. When you open a database in exclusive mode, you prevent others from opening the database.) access.
||View tables, queries, forms, reports, or macros in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
||View and change the design of tables, queries, forms, reports, or macros; or delete them.
For databases, set a database password, replicate (replication: The process of copying a database so that two or more copies can exchange updates of data or replicated objects. This exchange is called synchronization.) 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.
||View data in tables and queries.
||View and modify, but not insert or delete, data in tables and queries.
||View and insert, but not modify or delete, data in tables and queries.
||View and delete, but not modify or insert, data in tables and queries.
- 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, and modules (module: A collection of declarations, statements, and procedures stored together as one named unit. There are two types of modules: standard modules and class modules.) in a multiuser environment, you must open a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) exclusively, which means you must have Open Exclusive permission on the Access database.
- In general, if you want users to be able to access a linked table (linked table: A table stored in a file outside the open database from which Access can access records. You can add, delete, and edit records in a linked table, but you cannot change its structure.), grant them 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 they 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.