Chapter 35: Deploying Access Applications to SharePoint
1179
Table field issues
Fields in Access Services tables can contain a maximum of 220 fields. This number is less than the
255 fields permitted in Access tables, so you may have to redesign tables if the maximum column
count is exceeded.
Table name issues
The following are reserved words in SharePoint and cannot be used as table names: UserInfo, Lists,
Docs, WebParts, ComMd, Webs, Workflow, WFTemp, Solutions, Report Definitions, and
MSysASO.
Custom field formats are not compatible
Your tables cannot contain any custom formats for currency and dates (such as “MM/dd/yyyy”) in
field properties. You must use the predefined formats (Long Date, Short Date, and so on). The only
numeric formats acceptable to Access Services are General Number, Percent, and Standard.
Unique property must be false
The Unique property must be set to false for the following data types: Memo, Yes/No, and
Hyperlink.
AutoNumbers are reserved for primary keys
No field, other than a table’s primary key, can be an AutoNumber. Access Services reserves the
AutoNumber data type for primary keys only.
Summary
This chapter has looked at the new publish to SharePoint feature in Access 2010. The upsized
application runs in Access Services, a new SharePoint resource that permits relational tables, que-
ries, and other database objects to behave like a traditional Access application.
The publish to SharePoint technique described in this chapter is applicable only to Access 2010
and SharePoint 2010. You will not be able to publish an Access 2007 application to SharePoint
unless you open it in Access 2010.