Chapter 35: Deploying Access Applications to SharePoint
1177
Query join issues
The fields used to define joins between tables in a query must be compatible. Both fields must be
the same data type, such as text or numeric.
Invalid expression errors
Queries sometimes contain expressions that cannot be evaluated by Access Services. If a query fails
Compatibility Checker but otherwise seems valid, look closely at the query’s SQL statement to see
whether all the expressions are properly composed.
Invalid query name
Query names cannot begin with an equal sign (=) or include a period (.). Query names also cannot
include any of the following punctuation and special characters: exclamation mark (!), square
brackets ([]),
/ \ : *? “ < > | # { } % ~ &Queries cannot include subqueries
Access Services is unable to evaluate subqueries (queries used as input to other queries). You’ll
have to rewrite queries that use subqueries before publishing them to SharePoint.
Macro errors
Macros are another common source of compatibility errors. Most often, macro incompatibilities
stem from using macro actions that are unavailable in Access Services or whose names conflict
with SharePoint reserved words.
Reserved word collisions
The following words are reserved in SharePoint. Do not use the following words as the names of
database objects (tables, fields, forms, reports, queries, and so on): UserInfo, Lists, Docs, WebParts,
ComMd, Webs, Workflow, WFTemp, Solutions, Report Definitions, and MSysASO.
Incompatible macro actions
In addition to these issues, many macro actions are not compatible with Access services. You may
have to rewrite macros to eliminate these macro actions or convert macros to VBA procedures to work
around this limitation. The invalid macro actions include AddMenu, ApplyFilter, ApplyOrderBy, Beep,
CopyDatabase, CopyObject, DeleteObject, DisplayHourGlassPointer, Echo, EmailDatabaseObject,
FindNextRecord, FindRecord, GoToPage, ImportExportData, LockNavigationPane, MaximizeWindow,
MinimizeWindow, MoveAndSizeWindow, NavigateTo, OpenDataAccessPage, OpenDiagram,
OpenFunction, OpenModule, OpenQuery, OpenStoredProcedure, OpenTable, OpenView,
OutputTo, PrintOut, Quit, Rename, RepaintObject, Restore, RunApp, RunCommand (all options
other than UndoRecord, SaveRecord, and DeleteRecord), RunCode, RunSavedImportExport,
RunSQL, SearchForRecord, SelectObject, SendKeys, SetDisplayedCategories, SetMenuItem,