Using the Upsizing Wizard

As mentioned in the previous sections, the Upsizing Wizard, included with Access 2002, greatly facilitates the process of upsizing to a SQL Server database. To invoke the Upsizing Wizard, follow these steps:

1.
Select Tools, Database Utilities, Upsizing Wizard. The Upsizing Wizard appears (see Figure 3.7). Here you can opt to upsize to an existing SQL Server database or to create a new database.
Figure 3.7. The first step of the Upsizing Wizard allows you to create a new SQL Server database or to use an existing database.

2.
Make the appropriate selection and click Next. If you opt to create a new database, the Upsizing ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.