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. Also, users working with .accde files cannot make design changes to forms or reports.
Publishing any compiled database (.accde, .ade and .mde) is not supported.
Default SharePoint Permission Levels and Access Services Actions
SharePoint includes five permission levels by default. You can customize the permissions available in these permission levels, or you can create new permission levels that contain specific permissions. These are: Limited Access, Read, Contribute,
Windows 7 Pro, Design and Full Control. You can read more about these here.
Here is a table that shows the mapping between the default SharePoint permission levels and Access Services actions.
SharePoint
Permission Level
Access Services Actions
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 with permissions to the site (reader/contributor/designer) can view/change the objects in design view (forms/reports/macros/code) but ONLY designers can commit changes back to the server.
If you require compiling your code you should continue to use ACCDE’s.
*Updated Post to make the table view in Non-IE browsers <div