From 7edca7dc740f6877fa85c2a996ca869c6b971a48 Mon Sep 17 00:00:00 2001
From: jucasaca <jucasaca@gmail.com>
Date: Wed, 3 Apr 2024 18:15:39 +0200
Subject: tdf#158056 Connect to MS Access .mdb files by mean of ACE.OLEDB.12.0
 provider

* Modify the code so that all connections to MS Access files, both .mdb
and .accdb are made with the provider "Microsoft.ACE.OLEDB.12.0".
* Remove all references to the "Microsoft.Jet.OLEDB.4.0" provider to clean
up the code.
* Leave only one entry "Microsoft Access" in the Connection Wizard, which
would work for .mdb and .accdb files.
* Remove the entry "Microsoft Access 2007" from the Connection Wizard,
since it is no longer needed.

Change-Id: If523712d071199d61e0c994b35291d3a69246ad1
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/165756
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
---
 .../ado/org/openoffice/Office/DataAccess/Drivers.xcu  | 19 ++-----------------
 1 file changed, 2 insertions(+), 17 deletions(-)

(limited to 'connectivity/registry')

diff --git a/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu b/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu
index 288c23e2e497..28f915ff8e3e 100644
--- a/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu
+++ b/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu
@@ -214,7 +214,7 @@
         </node>
       </node>
     </node>
-    <node oor:name="sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=*" oor:op="replace">
+    <node oor:name="sdbc:ado:access:Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=*" oor:op="replace">
       <prop oor:name="Driver">
         <value>com.sun.star.comp.sdbc.ado.ODriver</value>
       </prop>
@@ -340,7 +340,7 @@
         </node>
         <node oor:name="Extension" oor:op="replace">
           <prop oor:name="Value" oor:type="xs:string">
-            <value>mdb</value>
+            <value></value>
           </prop>
         </node>
         <node oor:name="SupportsColumnDescription" oor:op="replace">
@@ -350,20 +350,5 @@
         </node>
       </node>
     </node>
-    <node oor:name="sdbc:ado:access:Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=*" oor:op="replace">
-      <prop oor:name="ParentURLPattern">
-        <value>sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=*</value>
-      </prop>
-      <prop oor:name="DriverTypeDisplayName" oor:type="xs:string">
-        <value xml:lang="en-US">Microsoft Access 2007</value>
-      </prop>
-      <node oor:name="MetaData">
-        <node oor:name="Extension" oor:op="replace">
-          <prop oor:name="Value" oor:type="xs:string">
-            <value></value>
-          </prop>
-        </node>
-      </node>
-    </node>
   </node>
 </oor:component-data>
-- 
cgit