Types of permissions (MDB)

 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.

Permission Permits a user to
Open/Run 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 Exclusive 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.
Read Design 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.).
Modify Design View and change the design of tables, queries, forms, reports, or macros; or delete them.
Administer

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.

Read Data View data in tables and queries.
Update Data View and modify, but not insert or delete, data in tables and queries.
Insert Data View and insert, but not modify or delete, data in tables and queries.
Delete Data View and delete, but not modify or insert, data in tables and queries.

 Notes 

 
 
Applies to:
Access 2003