Click the Machine
Data Source tab.
New Data Source dialog appears.
Select the System
Data Source radio button.
New Data Source dialog appears as depicted in Illustration 10.
necessary in the next Create New Data Source dialog that appears ("Select
a driver ..."), select the SQL Server driver, as shown in Illustration
third Create New Data Source dialog appears, confirming our selections, as
depicted in Illustration 12.
Illustration 12: The Confirmation Dialog
a New Data Source to SQL Server dialog appears.
following in the Name text box of the dialog:
following in the Description text box of the dialog:
Pubs DB Back End
In the Server
selector box, select the server to which you wish to connect (mine is MOTHER
in the illustrations).
a New Data Source to SQL Server dialog appears as shown in Illustration
Illustration 13: The Create a New Data Source to SQL
appropriate authentication setting for security by clicking the respective
radio button in the next dialog. (Mine is Windows NT authentication, as
depicted in Illustration 14.) Leave the other settings at default.
Illustration 14: Select the Appropriate Authentication
On the next
dialog to appear, click the radio button, named 'Change the default database
to:' to the left of the top entry, to activate it.
in the selector box immediately under Change the default database to: ,
and leave all other settings at default.
third Create a New Data Source to SQL Server dialog appears as shown in Illustration
Illustration 15: Dialog with Settings
next dialog of the series appears. We will leave all setpoints therein at
default, as shown in Illustration 16.
Illustration 16: Fourth Dialog, Create a New Data Source to
SQL Server Series
Microsoft SQL Server Setup dialog appears, confirming our configuration, as
depicted in Illustration 17.
Illustration 17: ODBC Microsoft SQL Server Setup Dialog
test the connection at this point to ascertain correct setup.
Click the Test
Data Source button on the ODBC Microsoft SQL Server Setup dialog.
Server ODBC Data Source Test message box appears momentarily, indicating we
have tested positive for connectivity, as shown in Illustration 18.
Illustration 18: SQL Server ODBC Data Source Test Message
Box - Connectivity Confirmed
to close the message box.
to close the ODBC Microsoft SQL Server Setup dialog that reappears.
returned to the Select Data Source dialog, Machine Data Source tab,
where we can see our new data source, Pubs DB, appear among the
selections, as shown in Illustration 19.
Illustration 19: Select Data Source Dialog - Machine Data
Source Tab, with Our New Source
the new data source Pubs DB is selected by clicking / highlighting it.
String Builder - Save Password dialog appears, as shown in Illustration
Illustration 20: Connection String Builder - Save Password
Here we can select Yes if we wish to save the logon /
password information within the connection string we are building (as
NOTE: Saving logon information in connection
strings carries inherent risk. Security of the data source may be compromised
by doing so. For more information, consult the MS Access documentation, MSSQL
Server 2000 Books Online, or other resources. Not saving the information
will result in our being asked for logon / password information each time we
attempt to access the back end via MS Access.