I’ve been tasked to work with old Microsoft Access database files (MDB). I have a lot of experience in this area. This time though, I’m developing my application on a Windows 7 64-bit system. I think all the ODBC work I’ve done in the past happened on Windows XP machines.
So I bring up the ODBC Data Source Administrator tool to try and add my MDB file. I could not find a way to add my new data source. All it listed was two SQL Server entries. Doing a quick Google search, it turns out the other data sources are security risks so they are “dissabled”.
If you ran into this same problem, navigate to ‘C:\windows\SysWOW64′ in Windows Explorer. Right-Click on ‘odbcad32.exe’ and select ‘Run as administrator’.
You should now be able to add MDB files as well as all the other formats that you could in Windows XP.
