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.
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
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
2 years ago