Datasheet

622
Checking Web compatibility
Your Access Web database applications can be shared across your organiza-
tion by being published to Access Services. If your database contains items
and settings that aren’t compatible with Access Services, your application
won’t publish correctly.
Use the Compatibility Checker that Access provides to check your database
before you publish it to SharePoint. If compatibility problems turn up, they
land in a table called Web Compatibility Issues.
Most errors that the Checker identifies usually happen because some
gremlin in the works tried to apply client-only features or settings (the
ones that are supposed to be disabled when an Access database becomes
a SharePoint site) to your database. You can avoid many of these errors
entirely by selecting the Web database template when you initially create
your database. Doing so filters out many of the client-only features prevent-
ing you from applying them to your database.
Follow these steps to check your Access database to see whether it’s com-
patible with the Access Services:
1. Open your Web database application in Access 2010.
2. Click the File tab to present the Access Backstage View.
3. Click the Save & Publish tab.
The save and publishing options appear.
4. In the Publish section, click Publish to Access Services.
The Compatibility Checker option appears on the right.
5. Click Run Compatibility Checker to check to see whether your Access
Web database is Web-compatible.
If you have any objects open in your database, a dialog box appears and
asks whether you want to close those objects. If you’ve saved all those
objects, click Yes to have Access close them.
The Compatibility Checker presents a dialog box that shows the prog-
ress as Access processes every object in the database to check for com-
patibility issues.
If your database is compatible with the Web, the Compatibility Checker dis-
plays a message to tell you so — and the Web Compatibility Issues button is
disabled.
If your database is incompatible (oh, the shame!), the Compatibility Checker
shows the following attributes:
Publishing to Access Services
31_587164-bk04ch01.indd 62231_587164-bk04ch01.indd 622 9/30/10 8:09 PM9/30/10 8:09 PM