O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required