Microsoft Access 2010 Bible

Part V: Access and Windows SharePoint Services

1158

FIGURE 35.13

Running Compatibility Checker is a requirement when publishing to SharePoint.

Share button Run Compatibility

Checker button

Publish to

Access Services

button

After running Compatibility Checker, the Backstage area looks different (see Figure 35.14).

Because incompatibilities were found, the Web Compatibility Issues button is enabled, and a mes-

sage is displayed explaining that the database is incompatible with SharePoint.

The Chapter35.accdb application generated six errors: two are issues with fields in tbl

Products and the others are related to the table relationships in the database. Figure 35.15

shows the Web Compatibility Issues table containing these six errors.

The Issue Type ID column in the Web Compatibility Issues table is important. The items in this

column are hyperlinks to a Microsoft Web site describing the error (see Figure 35.16). Microsoft

did a good job of documenting compatibility errors, and the ability to jump directly to an issue’s

explanation and suggested solution is useful.