On a 32bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Source (ODBC).
On a 64bit machine the ODBC can be found at Start > Programs > Control Panel > Administrative Tools > Data Source (ODBC)
Connecting to a 32bit Data Source on a 64bit machine
When connecting to a 32bit Data Source on a 64bit machine the 32bit ODBC Data Source Administrator which is found at C:\windows\syswow64\odbcad32.exe must be used.
Microsoft Access Database Engine
We recommend installing the 2010 Microsoft Access Database Engine (click to follow link) when communicating with any Microsoft Access database - both 32bit and 64bit versions are available.
This must be installed on each machine that the Data Source will be accessed from.
Step 1. | Select the System DSN Tab and click Add... | |
---|---|---|
Step 2. | Select a driver Microsoft Access Driver (*.mdb or *.accdb). This driver is going to be used to set up the Data Source. Click Finish. For Help on setting up SQL Server see How To: Setup a DSN-SQL Server | |
Step 3. | Give the new Data Source a name and click Select. | |
Step 4. | Now locate the Data Source. If the Data Source is shared over a network then click the Network and locate the required server. Once the Data Source has been located click OK. | |
Step 5. | If the .mdb/.accdb Data Source requires a password then this can be entered by clicking Advanced....Otherwise this will need to be entered when writing a rule for the Data Source. Click OK. |
Knowledge Base Article Ref: | KB13103016 |
---|