Access.2007.VBA.Bibl..

(John Hannent) #1
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 database name, check the “Attach database file-
name” checkbox, and type in the full file path and name for the database .mdf file in the “Attach
database filename” textbox.


  1. The settings on the screen shown in Figure 18.58 can generally be left at their defaults.


FIGURE 18.58
Various SQL Server settings.


  1. Click Finish to get a screen listing the ODBC data source configuration; click Test Data
    Source to test the connection to the database (see Figure 18.59).


FIGURE 18.59
The final screen of the ODBC SQL Server Setup Wizard.

TIPTIP


Part III Adding More Functionality to Office

Free download pdf