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)