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:

  1. 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.
  2. Click the System DSN tab, then click Add. The Create New Data Source dialog box opens. This dialog box lists the available ODBC drivers.
  3. From the list of drivers, select the Microsoft Access Driver and click Finish. The ODBC Microsoft Access Setup dialog box opens.
  4. 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.

  5. In the Description text box, type a description for the data source. For example, Connection to Silk Test Workbench database.
  6. Click Select and browse for your Access database.
  7. On the ODBC Microsoft Access Setup dialog box, click OK.
  8. On the ODBC Administrator dialog box, click OK to complete the process.