qgis
I am having an issue loading any ESRI personal geodatabase in QGIS 2.6. I have a number of files that worked in QGIS 2.4 and having done the upgrade I can't open them in 2.6.
I have tried this with installations based on the standalone installer and the OSGEO4W installer.
It affects geodatabases created in Arc 9.2, 9.3 and 10.0
Has anyone come across this issue? Am I missing something obvious?
Thank you for your inputs.
My source is an ESRI Personal Geodatabase (*.mdb). I can open the source in MS Access. The table GDB_ColumInfo, GDB_GeoColumns, GDB_ITEMRELATIONSHIPS, etc. and many Geometry-Table are there.
I have already created a successful connection on File (Datei) and File Type ESRI-Personal GeoDatabase (*.mdb). It runs, but it is a "READ ONLY" Connection.
But now, I want a Connection on Database (Datenbank) with the hope this will be a "READ-WRITE" Connection.
I read a lot in the forum, I must first install the correct Access Jet Driver. 32bit or 64 bit under MS Windows System Settings
I will now following the way from Michael Miles Stimson with northrivergeographic.com/qgis-accessing-personal-geodatabase
You need a 64-cross-32-bit driver. Searching for one is a little like a snipe hunt, but the driver is much more elusive. Esri doesn't support Personal Geodatabase with 64-bit Server or Desktop products because obtaining fully functional Jet drivers in 64-bit proved so difficult. If you're wedded to Access, you should probably stick to 32-bit applications.
Best Answer
When loading a personal ESRI geodatabase into QGIS mke sure you click on "Database" for source type instead of the standard "File" option. ESRI Personal Geodatabase should then be listed in the Database type as seen in the screenshot provided.
Hope this helps.