Export (0) Print
Expand All

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

 

Applies to: SharePoint Server 2010 Enterprise

Topic Last Modified: 2011-03-22

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.

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.

noteNote
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.
importantImportant
The publishing of any compiled database (.accde, .ade, or .mde) is not supported in Access Services.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft