Can't choose MS Acess as an option for a ODBC User DSN: why?

Question

I try to setup an User DSN using an MS Access driver, but although visible as an option in the User DSN tab I only can choose for SQL Server in the second dialog. Why?

I am using Windows 7 and Access 2007.

enter image description here

score 1 · Accepted Answer · answered May 06 '13 at 11:28

1

Found it myself: Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows.

So you have to use %windir%\SysWOW64\odbcad32.exe

answered May 06 '13 at 11:28

waanders

293

Can't choose MS Acess as an option for a ODBC User DSN: why?

1 Answers1