Microsoft Access 2010 Bible

Part VI: Access as an Enterprise Platform

1232

FIGURE 38.7

Waiting for the Upsizing Wizard to complete the conversion process

When the conversion process completes, the Upsizing Wizard automatically displays a report

snapshot of the upsizing process. An example of the report snapshot is shown in Figure 38.8. The

report snapshot includes information about each step of the conversion process for your applica-

tion. The Upsizing Wizard report contains information about the following:

l (^) Database details, including database size
l Upsizing parameters, including what table attributes you chose to upsize and how you
upsized
l Table information, including a comparison of Access and SQL Server values for names,
data types, indexes, validation rules, defaults, triggers, and whether timestamps were
added
l (^) Any errors, including database or transaction log full; inadequate permissions; device or
database not created; table, default, or validation rule skipped; relationship not enforced;
query skipped (because it can’t be translated to SQL Server syntax); and control and
record-source conversion errors in forms and reports