First, check which DSN the library is using: 1. Open the library. 2. Right click in the library and choose Properties. 3. In the "Data Source" tab, review the "Primary data source" field to see which DSN is being used.
Next, find out which database that DSN is pointing to: 4. Choose Start (> Settings, on Windows XP or Windows 10) > Control Panel > Administrative Tools > Data Sources (ODBC) 5. In the "ODBC Data Source Administrator" window, click the "File DSN" tab and select the DSN shown in step 3. 6. Click "Configure..." and on the resulting window, the Workbook (Excel), Database (Access), or Directory (dBase) path will be displayed. If it is truncated, click the Select button for more details.
|