Access 2010: ODBC connection driver is missing, won't reinstall.
Posted on 2011-03-21
One of my customers had installed Access 2010, 64 bit on Windows 7 64 bit.
It turned out that one of their software packages needed the 32 bit version in order to use ODBC otherwise it was giving an architecture mismatch error.
i had uninstalled the 64 bit version of access, reinstalled the 32 bit version of access and everything seemed fine as far as the odbc connection working from the 3rd party application.
However, i cannot edit the existing ODBC connection due to the following error:
the setup routines for the microsoft access driver (*.MDB, *.accdb) ODBC driver could not be found. Please reinstall the driver.
I also can't remove it due to that error, if i try to add a new connection access is missing from the options, it's also not listed on the drivers tab.
i have tried uninstalling/reinstalling access both 32 bit and 64 bit several times without it reinstalling.
Access is not listed under drivers in ODBC connections.
i also tried installing the 32 bit access database engine which that said it provided what was necessary for odbc connectivity but that doesn't work either. it looks like it installs OK but there is no access driver listed in ODBC connections.
Does anyone know how i can get the access 32 bit ODBC connection driver reinstalled?
One thing i have thought of is that i did not remove the ODBC connection before i uninstalled access x64 and reinstalled x32.
I tried going in to the registry and in the user's HKCU\software\ODBC and manually removing the problematic odbc connections, uninstall and reinstall access hoping that would let it show up but it's still not installed.