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:
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.
Make the appropriate selection and click Next. If you opt to create a new database, the Upsizing ...