https://bugs.documentfoundation.org/show_bug.cgi?id=158056
Bug ID: 158056
Summary: Connect to MS Access *.mdb files by mean of
Microsoft.ACE.OLEDB.12.0 provider
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Base, in Windows OS, has two specific options to connect to MS Access
databases: "Microsoft Access" and "Microsoft Access 2007".
In order to use these connections, the corresponding database engines must be
installed on the system.
The "Microsoft Access" connection uses the "Microsoft.Jet.OLEDB.4.0" engine as
data provider. This engine was used to connect to *.mdb databases and was
installed with certain versions of MS Access. Also it was available for
download and installation on Microsof's web pages, although for some time now,
this engine is no longer available for download on these pages.
The "Microsoft Access 2007" connection uses the "Microsoft.ACE.OLEDB.12.0"
provider. Although there is already a newer version, this provider can be
obtained from Microsoft's pages by downloading and installing the "Microsoft
Access Database Engine 2010 Redistributable".
Although the Jet.OLEDB.4.0 engine is not readily available, a connection to
*.mdb files can be established via the "Microsoft.ACE.OLEDB.12.0" provider used
by the "Microsoft Access 2007" connection, however, if in the database wizard
the "Microsoft Access 2007" connection is selected, it does not allow to select
*.mdb files because the pattern is set for *.accdb files only.
To achieve this improvement it should be done:
- Remove the connection that is made via the Jet.OLEDB.4.0 provider.
- Rename the connection made with the ACE.OLEDB.12.0 engine (probably to
"Microsoft Access" without "2007").
- Extend the pattern of this last connection so that *.mdb files can be opened.
Another alternative would be:
- Keep the connection to the Jet.OLEDB.4.0 engine (in case some user still has
this engine)
- Rename the connection "Microsoft Access 2007", for example to "Microsof
Access OLEDB.12" so that it does not specify the version of the file type but
the engine used.
- Add to this connection the *.mdb pattern to be able to open this type of
files.
Steps to Reproduce:
See description
Actual Results:
Connection to *.mdb files can not be established without Jet.OLEDB.4.0 engine
(not available)
Expected Results:
Establish connection to *.mdb files with ACE.OLEDB.12.0 engine
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
