How do I set up the Access ODBC driver on Windows 7?

Question

How do I set up the Access ODBC driver on Windows 7?

Anonymous

ODBC setup shows SQL Server driver is already installed. But my database is a local MS Access file. I want to choose the Access ODBC driver but it is not listed. Yes, Access is installed.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

3 additional answers

Answer 1

Is it Windows 7 64bit or 32bit

... check if this works for you

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/685eacc1-a670-42d4-8392-924230fa90cb

Try to find "odbcad32.exe" and execute the file

You can find the file located on

C:\Windows\SysWOW64\odbcad32.exe (IF it is Windows 7 64 bit)

and

C:\Windows\System32 (IF it is Windows 7 32 bit)

Answer 2

Is it Windows 7 64bit or 32bit

... check if this works for you

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/685eacc1-a670-42d4-8392-924230fa90cb

Try to find "odbcad32.exe" and execute the file

You can find the file located on

C:\Windows\SysWOW64\odbcad32.exe (IF it is Windows 7 64 bit)

and

C:\Windows\System32 (IF it is Windows 7 32 bit)

Its really helpful.......

Thanks a lot......................

Answer 3

Anonymous

thank u very much... If we search through ADMINSTRATIVE TOOLS->ODBC DATA SOURCE, there it shows reinstall ODBC driver properly. But when we go through above way it works thank you

0 comments

Answer 4

Anonymous

than you for your suggession.........

0 comments

Share via

How do I set up the Access ODBC driver on Windows 7?

3 additional answers