- Why This Chapter Is Important
- Understanding the Client/Server Model
- Deciding Whether to Use the Client/Server Model
- The Roles Access Plays in the Application Design Model
- Learning the Client/Server Buzzwords
- Upsizing: What to Worry About
- Proactively Preparing for Upsizing
- Using the Upsizing Wizard
- Defining an ODBC Data Source
- Connecting to a Database Server
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 Wizard appears, as in Figure 3.8.
Select the server where you want the database to reside.
Enter a login ID and password with privileges to create a database.
Enter a name for the new database. Click Next. The Upsizing Wizard appears, as in Figure 3.9.
Figure 3.8 The second step of the Upsizing Wizard allows you to designate the server, a login ID, a password, and other important information required when creating a new database.
Figure 3.9 The third step of the Upsizing Wizard allows you to select the tables that you want to upsize.
Select the tables that you want to export to SQL Server and click Next.
The next step of the Upsizing Wizard, shown in Figure 3.10, allows you to specify important information about what is included in the upsized tables. You can designate whether indexes, validation rules, defaults, and table relationships are upsized. You can also determine whether timestamps are added to the tables. Finally, you must designate whether table structures only or table structures and data are upsized. Make your selections and click Next.
- In the next step of the Upsizing Wizard, pictured in Figure 3.11, you can opt for Access to modify your database to create links to the new tables. If you prefer, Access will create an Access Data Project (ADP). Otherwise, you can opt for no application changes to be made. If you specify that you want access to create a new Access client/server application (ADP), you must specify the ADP filename. Click Next after making your selection.
Figure 3.10 The fourth step of the Upsizing Wizard allows you to designate whether indexes, validation rules, defaults, and table relationships are upsized.
Figure 3.11 In the fifth step of the Upsizing Wizard, you specify whether the wizard establishes table links or creates an Access Data Project file as part of the upsizing process.
Click Finish. The database is upsized. Access produces an Upsizing Wizard report (see Figure 3.12). You should review this report because it contains important information about the status of the upsizing process. Figure 3.13 shows the result of upsizing the Northwind database.
Figure 3.12 The Upsizing Wizard report provides important information about the upsizing process.
Figure 3.13 The Northwind database after upsizing.