[Qgis-user] RE: joining ms access to shapefile

[Koos Hagg]

Hi Jake,

I forgot to mention that the ODBC drivers for Access .mdb are 32 bit,
not 64, so if you just go through your regular control panel it
doesn't work.

the 32 bit ODBC driver utility is still on your computer, in
C:\Windows\System32, a .exe called "odbcad32.exe"
I usually copy this program to somewhere in my OSGeo4W folder so I
don;t have to go hunting for it every time.

Hope this helps,
Koos


------------

Date: Sun, 26 Feb 2012 06:49:28 -0500
From: "Jake Maier" <j.m at jmforestry.com>
Subject: RE: [Qgis-user] RE: joining ms access to shapefile

Thanks Koos,
I seem to have a problem with the drivers. Looking at the ODBC Data
Source Administrator I see the dBase Files, the Excel Files and the MS
Access Database listed under User DSN, but when I try to configure
them I get 2 messages. First "the setup routines for the Microsoft
Access Driver could not be found. Please reinstall the driver" and the
second "the specified DSN contains an architecture mismatch between
the Driver and Application". I seem not to be able to set up a driver,
but get stuck with empty choices in subsequent drop down lists Do you
(or anyone else) please point me in the right direction to reinstall
the drivers. The error messages show up for all three drivers
installed. Thanks for any help in advance
Jake