Access.2007.VBA.Bibl..

Getting through the Firewall.................................................................................... After working y ...

FIGURE 18.14 The Add a Program dialog for selecting an exception to the Windows XP firewall. First, browse for the SQL Server f ...

FIGURE 18.16 The SQL Server executable in the Add a Program dialog. Click OK, and you should see sqlserver.exe in the List of E ...

Windows Vista .............................................................................................. For the Windows Vis ...

FIGURE 18.19 Clicking the “Allow a program through Windows Firewall” link in the Security window. FIGURE 18.20 The Windows Firew ...

Click the “Add program” button to open the Add a Program dialog (Figure 18.21). Some SQL Server utilities are listed in the Pro ...

After clicking Open, sqlserver.exe will be listed in the Add a Program dialog, as shown in Figure 18.23. FIGURE 18.23 The SQL ...

FIGURE 18.24 The SQL Server executable and browser in the list of firewall exceptions. Other Security Roadblocks ............... ...

FIGURE 18.25 The Norton Internet Worm Protection warning. Using the Upsizing Wizard ............................................ ...

Converting Access Tables to SQL Server Tables ...................................................... To start the Upsizing Wizar ...

After clicking Next, you may be required to provide the name of your computer. To find the name of your computer, follow the ste ...

FIGURE 18.29 Finding out the full computer name in Windows XP for use in the SQL Server connec- tion syntax. On the second scree ...

FIGURE 18.30 Selecting the SQL Server instance to use for upsizing. If you get the rather formidable error message shown in Figu ...

FIGURE 18.32 Selecting Access tables for upsizing to SQL Server. I selected all the tables with data (leaving out tblBackupInfo ...

Next, you can select to create a new Access client/server application, or link the new SQL Server tables to the existing Access ...

You will get a dialog, shown in Figure 18.36, with a progress bar listing each table in turn. FIGURE 18.36 A progress bar as tab ...

The new SQL Server database is created in the SQL Server data folder, typically C:\Program Files\Microsoft SQL Server\MSSQL.1\MS ...

FIGURE 18.39 An Access form displaying data from a linked SQL Server table. Creating a Client/Server Application ............... ...

FIGURE 18.40 Selecting the client/server option for upsizing an Access database. On the next screen, shown in Figure 18.41, you ...

Next, you will get a dialog with a progress bar while the database objects are upsized (Figure 18.42). FIGURE 18.42 The Upsizing ...