﻿{"id":5404,"date":"2018-06-04T09:13:01","date_gmt":"2018-06-04T07:13:01","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=5404"},"modified":"2018-06-04T09:13:01","modified_gmt":"2018-06-04T07:13:01","slug":"acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0\/","title":{"rendered":"Acc\u00e9der \u00e0 une geodatabase personnelle ESRI avec QGis (2.18 ou 3.0)"},"content":{"rendered":"<p><span id=\"result_box\" class=\"\" lang=\"fr\" tabindex=\"-1\">Si vous avez install\u00e9 une version 64 bits de QGIS sous Windows et que vous trouvez que les GeoDatabases\u00a0 Personnelles (* .mdb) ne fonctionnent plus, cette solution peut r\u00e9soudre le probl\u00e8me.<\/span><!--more--><\/p>\n<p>Si vous n&rsquo;avez pas install\u00e9 Microsoft Office 64 bits sur votre machine, installez<a href=\"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><span id=\"result_box\" class=\"\" lang=\"fr\" tabindex=\"-1\"><span class=\"\">Cette m\u00e9thode r\u00e9sout le probl\u00e8me pour les versions 2.18 et 3.0 de QGis.<\/span><\/span><\/p>\n<p><span id=\"result_box\" class=\"\" lang=\"fr\" tabindex=\"-1\"><span class=\"\">Dans le panneau Variables d&rsquo;environnement des param\u00e8tres syst\u00e8me avanc\u00e9s de Windows, d\u00e9finissez les deux nouvelles variables suivantes en tant que variables utilisateur ou variables syst\u00e8me:<\/span><\/span><\/p>\n<p>nom de la variable : <strong>OGR_SKIP<\/strong><br \/>\nvaleur: <strong>ODBC<\/strong><\/p>\n<p>nom de la variable: <strong>PGEO_DRIVER_TEMPLATE<\/strong><br \/>\nvaleur: <strong>DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=%s<\/strong><\/p>\n<p>Pour charger une classe d&rsquo;entit\u00e9s de la geodatabase vous suivrez les pas suivants:<\/p>\n<h2>Pour QGis 2.18<\/h2>\n<p>Allez dans <em><strong>Couche-&gt; Ajouter une couche -&gt; Ajouter une couche vecteur<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im10.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5406\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0\/_im10-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im10.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=\"_im10\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im10.png?fit=640%2C226&amp;ssl=1\" class=\"aligncenter size-full wp-image-5406\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im10.png?resize=640%2C226\" alt=\"\" width=\"640\" height=\"226\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im10.png?w=777&amp;ssl=1 777w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im10.png?resize=300%2C106&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im10.png?resize=768%2C271&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Laissez l&rsquo;option Fichier s\u00e9lectionn\u00e9e, et cliquez sur <em><strong>Parcourir<\/strong><\/em><\/p>\n<p>Pointez sur la geodatabase personnelle.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im11.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5407\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0\/_im11-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im11.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=\"_im11\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im11.png?fit=640%2C588&amp;ssl=1\" class=\"aligncenter size-full wp-image-5407\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im11.png?resize=640%2C588\" alt=\"\" width=\"640\" height=\"588\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im11.png?w=660&amp;ssl=1 660w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im11.png?resize=300%2C275&amp;ssl=1 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Cliquez sur Ouvrir. Une fen\u00eatre s&rsquo;ouvre qui vous permet de choisir la ou les\u00a0 classes d&rsquo;entit\u00e9s contenues dans la geodatabase \u00e0 charger.<\/p>\n<h2><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im12.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5408\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0\/_im12-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im12.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=\"_im12\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im12.png?fit=587%2C269&amp;ssl=1\" class=\"aligncenter size-full wp-image-5408\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im12.png?resize=587%2C269\" alt=\"\" width=\"587\" height=\"269\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im12.png?w=587&amp;ssl=1 587w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im12.png?resize=300%2C137&amp;ssl=1 300w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a>Pour QGis 3.0<\/h2>\n<p>Allez dans <em><strong>Couche-&gt; Ajouter une couche -&gt; Ajouter une couche vecteur<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im13.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5409\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0\/_im13-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im13.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=\"_im13\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im13.png?fit=640%2C200&amp;ssl=1\" class=\"aligncenter size-full wp-image-5409\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im13.png?resize=640%2C200\" alt=\"\" width=\"640\" height=\"200\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im13.png?w=827&amp;ssl=1 827w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im13.png?resize=300%2C94&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im13.png?resize=768%2C240&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Laissez l&rsquo;option Fichier s\u00e9lectionn\u00e9e, et cliquez sur le<em><strong> bouton &#8230; <\/strong><\/em>de la section <em><strong>Source.<br \/>\n<\/strong><\/em><\/p>\n<p>Pointez sur la geodatabase personnelle.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im14.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5410\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0\/_im14-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im14.png?fit=1001%2C568&amp;ssl=1\" data-orig-size=\"1001,568\" 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=\"_im14\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im14.png?fit=640%2C363&amp;ssl=1\" class=\"aligncenter size-full wp-image-5410\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im14.png?resize=640%2C363\" alt=\"\" width=\"640\" height=\"363\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im14.png?w=1001&amp;ssl=1 1001w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im14.png?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im14.png?resize=768%2C436&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Cliquez sur le bouton <em><strong>Ajouter. <\/strong><\/em>Une fen\u00eatre s&rsquo;ouvre qui vous permet de choisir la ou les\u00a0 classes d&rsquo;entit\u00e9s contenues dans la geodatabase \u00e0 charger.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im15.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"5411\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/acceder-a-une-geodatabase-personnelle-esri-avec-qgis-2-18-ou-3-0\/_im15-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im15.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=\"_im15\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im15.png?fit=640%2C360&amp;ssl=1\" class=\"aligncenter size-full wp-image-5411\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im15.png?resize=640%2C360\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im15.png?w=833&amp;ssl=1 833w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im15.png?resize=300%2C169&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2018\/05\/im15.png?resize=768%2C431&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si vous avez install\u00e9 une version 64 bits de QGIS sous Windows et que vous trouvez que les GeoDatabases\u00a0 Personnelles (* .mdb) ne fonctionnent plus, cette solution peut r\u00e9soudre le probl\u00e8me.<\/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":[209,146,62],"tags":[15,44,58],"class_list":["post-5404","post","type-post","status-publish","format-standard","hentry","category-arcgisqgis","category-arcmap","category-qgis-2","tag-arcgis","tag-geodatabase","tag-qgis"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-1pa","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/5404","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=5404"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/5404\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=5404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=5404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=5404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}