﻿{"id":5442,"date":"2018-06-04T10:24:08","date_gmt":"2018-06-04T08:24:08","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=5442"},"modified":"2018-10-17T12:50:03","modified_gmt":"2018-10-17T10:50:03","slug":"access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0\/","title":{"rendered":"Access an ESRI Personal Geodatabase with QGis (2.18 or 3.0)"},"content":{"rendered":"<p>If you have installed a\u00a064-bit\u00a0version\u00a0of QGIS on Windows and you find that GeoDatabases\u00a0\u00a0\u00a0Personal (* .mdb) does not work anymore, this solution can solve the problem.<!--more--><\/p>\n<p>If you did not install Microsoft Office 64-bit on your machine, install\u00a0<a href=\"https:\/\/translate.google.com\/translate?hl=en&amp;prev=_t&amp;sl=fr&amp;tl=en&amp;u=https:\/\/download.cnet.com\/Microsoft-Access-Database-Engine-2010-Redistributable-64-bit\/3000-10254_4-75452796.html\">\u00a0<\/a>\u00a0<a href=\"https:\/\/translate.google.com\/translate?hl=en&amp;prev=_t&amp;sl=fr&amp;tl=en&amp;u=https:\/\/download.cnet.com\/Microsoft-Access-Database-Engine-2010-Redistributable-64-bit\/3000-10254_4-75452796.html\">microsoft access database engine 64 bit.<\/a><\/p>\n<p>This method solves the problem for QGis versions 2.18 and 3.0.<\/p>\n<p>In the Environment Variables panel of Windows Advanced System Settings, set the following two new variables as user variables or system variables:<\/p>\n<p>name of the variable:\u00a0\u00a0\u00a0<strong>OGR_SKIP<\/strong><br \/>\nvalue:\u00a0\u00a0\u00a0<strong>ODBC<\/strong><\/p>\n<p>name of the variable:\u00a0\u00a0\u00a0<strong>PGEO_DRIVER_TEMPLATE<\/strong><br \/>\nvalue:\u00a0\u00a0\u00a0<strong>DRIVER = Microsoft Access Driver (* .mdb, * .accdb); DBQ =% s<\/strong><\/p>\n<p>To load a feature class from the geodatabase you will follow the following steps:<\/p>\n<p><strong>For QGis 2.18<\/strong><\/p>\n<p>Go in\u00a0\u00a0\u00a0<strong><em>Layer-&gt; Add Layer -&gt; Add Vector Layer<\/em><\/strong><\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5443\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0\/acc1\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc1.png?fit=777%2C274&amp;ssl=1\" data-orig-size=\"777,274\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"acc1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc1.png?fit=640%2C226&amp;ssl=1\" class=\"alignnone size-medium wp-image-5443\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc1-300x106.png?resize=300%2C106\" alt=\"\" width=\"300\" height=\"106\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc1.png?resize=300%2C106&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc1.png?resize=768%2C271&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc1.png?w=777&amp;ssl=1 777w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Leave the File option selected, and click\u00a0\u00a0\u00a0<strong><em>Browse<\/em><\/strong><\/p>\n<p>Point to the personal geodatabase.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5444\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0\/acc2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc2.png?fit=660%2C606&amp;ssl=1\" data-orig-size=\"660,606\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"acc2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc2.png?fit=640%2C588&amp;ssl=1\" class=\"alignnone size-medium wp-image-5444\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc2-300x275.png?resize=300%2C275\" alt=\"\" width=\"300\" height=\"275\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc2.png?resize=300%2C275&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc2.png?w=660&amp;ssl=1 660w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Click Open.\u00a0A window opens that allows you to choose one or\u00a0various\u00a0feature classes contained in the geodatabase to load.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5445\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0\/acc3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc3.png?fit=587%2C269&amp;ssl=1\" data-orig-size=\"587,269\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"acc3\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc3.png?fit=587%2C269&amp;ssl=1\" class=\"alignnone size-medium wp-image-5445\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc3-300x137.png?resize=300%2C137\" alt=\"\" width=\"300\" height=\"137\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc3.png?resize=300%2C137&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc3.png?w=587&amp;ssl=1 587w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><strong>For QGis 3.0<\/strong><\/p>\n<p>Go in\u00a0\u00a0\u00a0<strong><em>Layer-&gt; Add Layer -&gt; Add Vector Layer<\/em><\/strong><\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5446\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0\/acc4\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc4.png?fit=827%2C258&amp;ssl=1\" data-orig-size=\"827,258\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"acc4\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc4.png?fit=640%2C200&amp;ssl=1\" class=\"alignnone size-medium wp-image-5446\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc4-300x94.png?resize=300%2C94\" alt=\"\" width=\"300\" height=\"94\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc4.png?resize=300%2C94&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc4.png?resize=768%2C240&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc4.png?w=827&amp;ssl=1 827w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Leave the File option selected, and click on the\u00a0<strong><em>\u00a0<\/em><\/strong>\u00a0<strong><em>button &#8230;<\/em><\/strong>\u00a0<strong><em>\u00a0<\/em><\/strong>\u00a0section\u00a0\u00a0\u00a0<strong><em>Source.<\/em><\/strong><\/p>\n<p>Point to the personal geodatabase.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5447\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0\/acc5\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc5.png?fit=840%2C477&amp;ssl=1\" data-orig-size=\"840,477\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"acc5\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc5.png?fit=640%2C363&amp;ssl=1\" class=\"alignnone size-medium wp-image-5447\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc5-300x170.png?resize=300%2C170\" alt=\"\" width=\"300\" height=\"170\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc5.png?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc5.png?resize=768%2C436&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc5.png?w=840&amp;ssl=1 840w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Click on the button\u00a0\u00a0\u00a0<strong><em>Add.<\/em><\/strong>\u00a0<strong><em>\u00a0<\/em><\/strong>\u00a0A window opens that allows you to choose one or\u00a0various\u00a0\u00a0Feature classes contained in the geodatabase to load.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5448\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/access-an-esri-personal-geodatabase-with-qgis-2-18-or-3-0\/acc6\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc6.png?fit=833%2C468&amp;ssl=1\" data-orig-size=\"833,468\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"acc6\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc6.png?fit=640%2C360&amp;ssl=1\" class=\"alignnone size-medium wp-image-5448\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc6-300x169.png?resize=300%2C169\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc6.png?resize=300%2C169&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc6.png?resize=768%2C431&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/06\/acc6.png?w=833&amp;ssl=1 833w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have installed a\u00a064-bit\u00a0version\u00a0of QGIS on Windows and you find that GeoDatabases\u00a0\u00a0\u00a0Personal (* .mdb) does not work anymore, this solution can solve the problem.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1260],"tags":[],"class_list":["post-5442","post","type-post","status-publish","format-standard","hentry","category-non-classe-en"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-1pM","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/5442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=5442"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/5442\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=5442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=5442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=5442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}