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.