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

[Jake Maier]

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

-----Original Message-----
From: qgis-user-bounces at lists.osgeo.org
[mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Koos Hagg
Sent: Saturday, February 25, 2012 8:26 PM
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] RE: joining ms access to shapefile

Hi Jake,

I have worked a bit with Access and QGIS together...from my experience it
works best when your database is saved in an older format (.mbd).

You can add the .mdb as an ODBC connection or (if I remember
correctly) the better way is to add it simply as a vector layer.

The only thing I don't like about it is that it is a static connection (read
only), but it works...

Koos

>Date: Sat, 25 Feb 2012 14:00:11 -0500
>From: "Jake Maier" <j.m at jmforestry.com>
>Subject: [Qgis-user] joining ms access to >shapefile
>To: <qgis-user at lists.osgeo.org>

>Hi I'm new to qgis (I have some ArcMap >experience) and I'm having 
>problems joining a ms access database to a shapefile. I'm >using 
>windows 7 and ms office 2007. I tried to google the information >about 
>a join of access to shapefile but got more confused in the process
>instead.
>Can anyone please help and give me some pointers.
>Thank you very much
>Jake
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user