Microsoft Access 2010 Bible

Part V: Access and Windows SharePoint Services

1140

FIGURE 34.2

The Access Services Overview area in the Backstage area

Share button Run Compatibility Checker
button

Publish to Access

Services button

Understanding Access Services

Previously in the chapter, you read that only SharePoint Server 2010 supports the full range of

Access Web publishing options. This is because SharePoint Server 2010 is the first version to sup-

port Access Services, the server-side support necessary for hosting Access applications in

SharePoint.

Access applications are built in Access, of course, using essentially the same tools as in previous

versions of Access. When the application is published to SharePoint, Access Services renders the

ASPX pages necessary to display the Access application in a Web browser. In other words, Access

Services is the driving force behind SharePoint-hosted Access applications.

Access Services also compiles and executes the queries in the Access Web application and directs

the queries against the SharePoint lists containing the data. Access Services also synchronize

updates between versions of the Access application on a developer’s desktop and the version stored

in SharePoint (these steps are described in detail in Chapter 35).