Runtime Error 3706 appears when a Microsoft Access installed in a Windows computer attempts to create a database connection with a particular ODBC driver and is unable to find the driver in the System DSN. This error usually occurs when the specified driver is either not on the system or is not properly configured.
Solution
To fix this issue, you will need to download and install the most up-to-date version of the ODBC driver that you are attempting to use and then configure the System DSN to use the driver.
Prerequisites
- Access to an administrator user account on the computer
- Downloaded ODBC driver
Step 1: Install the Version of the ODBC driver
- Log into the administrator user account.
- Go to the Microsoft website and search for the version of the ODBC driver that you need.
- Download the driver and click to install the driver.
- Follow the on-screen instructions to finish the installation.
Step 2: Configure the System DSN
- Open the Windows Control Panel and select Administrative Tools.
- Double click to open the ODBC Data Source Administrator.
- In the ODBC Data Source Administrator window, select System DSN.
- Click the Add button on the System DSN tab to open the Create New Data Source window.
- Select the ODBC driver that you have installed and click Finish.
- In the Configuration tab of the ODBC driver configuration window, enter the information required for the ODBC driver and click OK.
FAQ
Q. What is Runtime Error 3706?
A. Runtime Error 3706 is an error that occurs when a Microsoft Access installed in a Windows computer attempts to create a database connection with a particular ODBC driver and is unable to find the driver in the System DSN.
Q. How do I fix Runtime Error 3706?
A. The solution is to download and install the most up-to-date version of the ODBC driver that you are attempting to use. Once the driver is installed, you can then configure the System DSN to use the driver.