Access.2007.VBA.Bibl..

(John Hannent) #1
FIGURE 18.30
Selecting the SQL Server instance to use for upsizing.

If you get the rather formidable error message shown in Figure 18.31 when clicking Next on the
second screen of the Upsizing Wizard, review your SQL Server settings; you may have missed one
or more of the setup steps required for Access to connect to SQL Server.

FIGURE 18.31
An error message when trying to connect to SQL Server.

If you get the Norton Internet Worm Protection warning (shown in Figure 18.25), click
OK on it before clicking Next on the second screen of the Upsizing Wizard.

If you don’t run into one or another roadblock, you will get the third screen of the Upsizing
Wizard, shown in Figure 18.32, listing the tables in the Access database for selection.

NOTENOTE


Part III Adding More Functionality to Office

Free download pdf