Coordinating Access Services actions with SharePoint permission levels (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010 Enterprise

By default, Microsoft SharePoint Server 2010 includes five permission levels. You can customize the permissions that are available in these permission levels, or you can create new permission levels that contain specific permissions. The permission levels are Full Control, Design, Contribute, Read, and Limited Access.

Default SharePoint permission levels and Access Services actions

The following table shows the mapping between the default SharePoint Server 2010 permission levels and Access Services in Microsoft SharePoint Server 2010 actions.

SharePoint permission level Access Services action

Read Data

Open in Access (rehydrate/take offline)

Modify/Add Data

Create/Modify Objects & Sync

Create/Edit Schema

Publish

Full Control

Yes

Yes

Yes

Yes

Yes

Yes

Design

Yes

Yes

Yes

Yes

Yes

Yes

Contribute

Yes

Yes

Yes

No

No

No

Read

Yes

Yes

No

No

No

No

Limited Access

Yes

Yes

No

No

No

No

Any user who has permissions to the site (such as a reader, contributor, or designer) can view or change the objects in design view (such as forms, reports, macros, or code). However, only a designer can commit changes back to the server. If your code must be compiled, you should continue to use .accde files.

Note

An .accde file is a "locked-down" version of the original .accdb file. If the .accdb file contains any VBA code, only the compiled code is included in the .accde file. As a result, the VBA code cannot be viewed or modified by the user. Users who work with .accde files cannot make design changes to forms or reports.

Important

The publishing of any compiled database (.accde, .ade, or .mde) is not supported in Access Services.

See Also

Other Resources

User permissions and permission levels (SharePoint Foundation 2010)