FIGURE 18.29
Finding out the full computer name in Windows XP for use in the SQL Server connec-
tion 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 back-
slash 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.CAUTION CAUTION
Working with SQL Server Data 18