After clicking Next you may be required to provide the name of your computer To find the name of your computer follow the steps below depending on your Windows version

■ For Windows Vista, first select the System and Maintenance link in the Control Panel.

■ On the System and Maintenance page, click the "See the name of this computer" link under the main System link. The full computer name is located in the "Computer name, domain, and workgroup settings" group, as shown in Figure 18.28.

FIGURE 18.28

Finding out the full computer name in Windows Vista for use in the SQL Server connection syntax.

FIGURE 18.28

■ For Windows XP, open the properties sheet for the My Computer icon on your desktop (or the System shortcut in the Control Panel), and click the Computer Name tab (Figure 18.29); the full computer name (with an extra terminating period) is listed in the middle of the page.

Finding out the full computer name in Windows XP for use in the SQL Server connection syntax.

On the second screen of the wizard, shown in Figure 18.30, select the running instance of SQL Server, using a name composed of the name of your computer followed by a backslash and SQLEXPRESS, check the Use Trusted Connection checkbox, and edit the proposed database name as desired.

If you are running Windows XP, most likely the default selection in the SQL Server box will be "(local)". Help for the Upsizing Wizard (and various documents in SQL Server Books Online) recommends using this selection, but I have found that it doesn't work; the only syntax that works on my system is DELL_DIMEN_8300\SQLEXPRESS, where the portion before the backslash is my computer name (this is the default syntax if you are running Windows Vista). I found this syntax using Google; as usual, Google has proved to be of more help in finding information on using Access 2007 than Microsoft's own Help resources. However, you may find that the "(local)" selection works, or perhaps some other syntax, such as the name you gave SQL Server when you installed it.

FIGURE 18.30

Selecting the SQL Server instance to use for upsizing.

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.

0 0

Post a comment