Setting User and Group Permissions

Setting User and Group Permissions

Once you have defined users and groups, you will want to define permissions for them. Permissions indicate the ability of each user or group to modify databases or database objects. Permissions also control a user's ability to create new objects. For example, you might want to limit the ability to view the Salaries table to a small group of users, and limit the ability to edit that table to an even smaller group.

Change Account Permissions


Start Access, type Admin as the user name , press Tab, and then enter the password for the Admin account.


Click the Tools menu, point to Security, and then click User And Group Permissions.


Click the Permissions tab.


Click the Users option or the Groups option, depending on whether you want to modify the rights of individual users or entire groups.


Click the name of the person or group for whom you want to change permissions.


Click the Object Type list arrow, and then select an object type.


Click the name of an existing object or click <New Object>.


Select the applicable check boxes to add or remove permissions for the selected object.


Click Apply.


Click OK.


Select Permissions

  • When you add or remove permissions for a selected object, refer to the Database Permissions table to the right.

Database Permissions


Permits a User to



Open a database, form, or report, or run a macro

Databases, forms, and macros

Open Exclusive

Open a database with exclusive access


Read Design

View objects in Design view

Tables, queries, forms, macros, and modules

Modify Design

View and change the design of objects, or delete them

Tables, queries, forms, macros, and modules


Have full access to objects and data, including the ability to assign permissions

Tables, queries, forms, macros, and modules

Read Data

View data

Tables and queries

Update Data

View and modify data

Tables and queries

Insert Data

View and insert data

Tables and queries

Delete Data

View and delete data

Tables and queries

Did You Know?

You can set personal identifiers for user accounts . Personal IDs contain between 4 and 20 letters (capitalization matters) or numbers or both. Along with the account name, a personal ID uniquely tags a user or group in a workgroup. Make sure you keep a copy of both the personal ID and account name in a secure location in case you need to retrieve an account that has been accidentally deleted or moved.

You can simplify user permissions . Instead of assigning permissions to each user, assign permissions to groups, and then add users to the appropriate groups.

You can print a list of permissions . Use the Documenter to print a report describing the permissions for each object in the database.

Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318 © 2008-2017.
If you may any questions please contact us: