Figure

The Upsizing Wizard progress bar dialog.

Upsizing Wizard

Creating extended properties...

iii

[ Cancel |

The Upsizing Wizard report opens in Print Preview; with the client/server option selected, queries and forms (and other database objects, if present) will be upsized as well as tables. The report shows which queries were upsized, and which were not, with the reasons (see Figure 18.43).

FIGURE 18.43

The Upsizing Wizard report.

FIGURE 18.43

The Upsizing Wizard report.

Forms based on tables, or queries that were successfully upsized, will look the same in the project as in the original database (see Figure 18.44).

FIGURE 18.44

A form in an Access project displaying data from a SQL Server table.

FIGURE 18.44

If you attempt to upsize queries as well as tables, you will find that some query types don't upsize at all, because they don't match up with views or stored procedures in SQL Server. Crosstab queries, for example, can't be upsized at all, nor can any query that uses a function in a calculated field expression. If a query isn't upsized, you need to re-create it as a SQL Server object of the appropriate type (view or stored procedure).

0 0

Post a comment