How to connect to MS Access DB with ODBC on Windows 7

• zendnwar
• July 1, 2013
• Others
• 0 Comments

1. Open the app ODBC Data Source Administrator in Windows 7 (search ODBC from Start Menu).
2. Under User DSN tab, click the Add… button.
3. In the Create New Data Source dialog select Microsoft Access Driver (*.mdb), click Finish button.
4. A new dialog box opens, called ODBC Microsoft Access Setup, now click Select button to select database, notice the Windows 3.1 browse box to find the database.

If you face any problem due to 32bit system type. You have to work little bit. Please follow my below instruction.

IF your PC system type 64bit please goto Control panel and Administrative tools.

Please click right button on Data Sources(ODBC) and goto Properties.

May be Target  %WINDIR%\System32\odbcad32.exe

Please Replace your target with this %WINDIR%\SysWOW64\odbcad32.exe

Hope it will help you.