Wednesday, July 12, 2017

How to get 32-bit ODBC drivers for MS Access 2007/2010 on a Windows 7 64-bit System

Found the following off Microsoft’s Website & other Technical Tech-net Forums regarding users having issues setting up ODBC drivers for legacy 32-bit Access databases for shared connectivity to other 32-bit software applications needing to use older ODBC legacy connectivity instead of the newer Jet4.0/OLE.

Issue seen is when going under the normal “32-bit ODBC administrator” found under
Control Panel System & Security Administrative Tools Data Sources (ODBC) – ODBC Data Source Administrator and select “System DSN”
There are not any *.mdb, *.accdb, *.xls or *.xlsx drivers to select from for adding a System DSN –ODBC driver connection, these drivers are missing…only will see one driver for a “SQL Server”(as shown in the captured picture below):



The solution/workaround found on Microsoft/Technet websites recommend to do the following to obtain these ODBC drivers via the “64-bit ODBC Administrator”:



32 bit ODBC driver for MS Access 2010 (*.accdb) is missing in Win7 64bit
If you are running a 64-bit Computer and Running Access 2010, you will first need to download the AccessDatabaseEngine.exe
from Microsoft.
http://www.microsoft.com/downloads/en/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
After the download finishes, and installs, You will need to create an ODBC connection. Instead of creating an ODBC connection through your Administrative Tools, Data Sources (ODBC) interface, you will need to run the 64-bit instance of Data Sources (ODBC). To do this, you will need to click your "Windows" + "R" buttons on the keyboard, and then paste "c:\windows\sysWOW64\odbcad32.exe" -- without quotes into the dialog. Then create the connection to the database as you
would on a 32 bit machine.

Source: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=8&cad=rja&uact=8&ved=0ahUKEwiZ2aaEzoXVAhWJHxoKHarHDesQFghaMAc&url=http%3A%2F%2Fwww.weberpackaging.com%2Fpdfs%2FHow%2520to%2520get%252032_bit%2520ODBC%2520Drivers%2520on%2520Win7_64bit%2520PC.pdf&usg=AFQjCNHdvu2wx7k1uFdTru-xpgSsksmjew