Creating a Data Source Name for an Access Database
On each client computer connecting to an Access database, perform the following steps to set up a DSN:
Navigate (in
Microsoft Windows 7) to
Start > Silk > Silk Test > Administration > Data Sources (ODBC) or (in
Microsoft Windows 10) to
Start > Windows Administrative Tools > ODBC Data Sources (32-bit).
The
ODBC Data Source Administrator dialog box opens.
Click the
System DSN tab, then click
Add.
The
Create New Data Source dialog box opens. This dialog box lists the available ODBC drivers.
From the list of drivers, select the
Microsoft Access Driver and click
Finish.
The
ODBC Microsoft Access Setup dialog box opens.
In the
Data Source Name text box, type the data source name.
Enter a logical name as this name appears as the database name in the logon dialog box.
In the
Description text box, type a description for the data source.
For example,
Connection to
Silk Test Workbench database.
Click
Select and browse for your Access database.
On the
ODBC Microsoft Access Setup dialog box, click
OK.
On the
ODBC Administrator dialog box, click
OK to complete the process.