Microsoft Office Tutorials and References
In Depth Information
5. Enter a name, description, and server for the data source.
Specifically, fill out the following fields:
• Name: Enter whatever name you want to give the data source. The
name you enter here is what Access will use to refer to the ODBC
connection. (Keeping the name short and memorable is helpful, in
case you need to create it on another computer.)
• Description: Type something more descriptive than just the name so
that later, you’ll know what the data source connects to. You might
enter a description like Contact Database on SERVER1, for example.
• Server: In this field, enter the pertinent server name or IP address,
followed by the name of the server you want to connect to. If you
don’t know the address or name of the server, contact the database
administrator for help.
If your network has registered servers, you can simply choose one from
the Server drop-down menu.
6. When you finish filling out these fields, click Next to display a screen
that lets you configure how you log in to the server (see Figure 2-6).
7. Make one of the following choices and then click Next:
• With Windows NT Authentication Using the Network Login ID: Choose
this option if the username and password for the server match the
username and password you use to log in to your computer.
• With SQL Server Authentication Using a Login ID and Password Entered
by the User: Choose this option if you have a separate username and
password for SQL Server. If you choose this option, enter the login ID
and password at the bottom of the dialog box.
When you click Next, you see a slew of additional options for
connecting to the server, as shown in Figure 2-7. The only option you need to be
concerned with is the first one.