Access.2007.VBA.Bibl..

Forms based on tables, or queries that were successfully upsized, will look the same in the project as in the original database ...

FIGURE 18.45 Four upsized queries in an Access project. FIGURE 18.46 A SQL Server view created from an Access query. Working wit ...

FIGURE 18.47 A user-defined function created from an Access query. Linking to Data in SQL Server Tables ........................ ...

FIGURE 18.48 Creating the new blank database. FIGURE 18.49 Starting the process of linking to a SQL Server database. Working wit ...

On the Get External Data screen (Figure 18.50), select the Link option. FIGURE 18.50 Choosing to link to the data source. On ...

Select the SQL Server driver on the Create New Data Source screen (Figure 18.52) and click Next. FIGURE 18.52 Selecting the SQ ...

The Finish screen (Figure 18.54) lists the DSN name and driver you selected. (This is only the end of the DSN portion of this w ...

On the Authentication screen (Figure 18.56), generally you can accept the default selec- tion of Windows NT authentication. FI ...

If the database you want to connect to doesn’t appear in the “Change the default data- base to” drop-down list, type in the data ...

You should get the success screen depicted in Figure 18.60. FIGURE 18.60 A success message on getting a connection to a SQL Se ...

On clicking OK, you will get the Link Tables screen, shown in Figure 18.62, where you can select the tables to link to the Acce ...

Now, as in Figure 18.64, you can see the linked SQL Server tables in the Access database window. FIGURE 18.64 Linked SQL Serve ...

Using Access as a front end to SQL Server is a topic worthy of a complete book on its own, but the Upsizing Wizard will at least ...

SYMBOLS ' (apostrophe), 366 \ (backslash), 267, 268 A .accda file format, 472, 473, 505, 511. See alsoadd- ins, Access .accdb fi ...

Access (continued) placing indicators in Word templates where data should appear, 30–45 preparing databases for upsizing to SQL ...

AddToCommandBarfunction, 440 ADO object model code limitations, 129 Command object, 113–116 Connection object, 110–113 convertin ...

Basic Northwind.accdb sample database, 627, 631, 648, 656 batch optimistic lock type, 118 Beginning XML(Wiley Publishing), 525 B ...

creating LNC Control Renaming add-in, 440–463 customizing add-ins, 438–440 installing add-ins, 463–466 selecting add-in template ...

content controls, inserting into Word templates, 45–48 ControlCAfunction, 456–457 ControlCSfunction, 454–456 ControlNAfunction, ...

illustrated, 97 new objects, 97–98 old versus new, 90, 96–109 overview, 96 QueryDefs, 104–106 recordsets, 99–104 support in Acce ...