Microsoft Access 2010 Bible

Chapter 35: Deploying Access Applications to SharePoint

1163

The change to tblSales is superficial. The only visible difference is that tblCustomers now

appears as a drop-down list (see Figure 35.21). Because we chose to enforce data integrity on the

lookup, the user must select a CustomerID value from this list when adding new customers.

FIGURE 35.21

Access uses a drop-down list for the CustomerID lookup field in tblSales.

Compatibility Checker is quite thorough. Even a simple Access application may generate dozens of

items that must be corrected before publishing to Access Services. The section titled “Dealing with

Compatibility Checker Problems,” later in this chapter, describes some of the more common issues

reported by Compatibility Checker and suggests ways to resolve these issues.

After correcting the problems reported in the Web Compatibility Issues table, run Compatibility

Checker again (and again, if necessary!) until “The database is compatible with the Web” message

appears just below the Compatibility Checker button and the Web Compatibility Issues button

remains disabled (see Figure 35.22).