I am trying to set up a an ODBC link to Access 2007 32-bit but not having any success. My system is a win7 pro 64-bit and I have QGIS 64-bit installed. Here are the steps I have already tried.
Set up an ODBC link using c:\windows\syswow64\odbcad32.exe. However, when I try to use that, the error message states that there is an architecture mismatch, which I assume means between 64- and 32-bit architecture.
Tried to set up the ODBC link from the standard location in Control Panel, but the error is that the Microsoft Access driver isn't installed.
Downloaded the Microsoft Access 64-bit Runtime, but when installing the error comes up that the 32-bit Access is installed and the 64-bit Runtime cannot be installed.
I am not sure where to go from here.
I know that I can change databases and go with a spatial system, but this is a regular download from a government site, which would mean a lot of extra work. Any assistance would be much appreciated.