Access.2007.VBA.Bibl..

You will get a dialog, shown in Figure 18.36, with a progress bar listing each table in turn.

FIGURE 18.36

A progress bar as tables are upsized.

Finally, an Upsizing Wizard report is created and opened in Print Preview; you can print this report

to get detailed information about the upsizing process, with lists of table fields for the tables that

were successfully upsized, and a report on the error that prevented upsizing for any tables that

could not be upsized. Figure 18.37 shows the page for the tblCategories table, listing the Access

and SQL Server fields in two columns for comparison.

FIGURE 18.37

The Upsizing Wizard report.

Working with SQL Server Data 18