Description: Crash if I connect to a MS Access database Steps to Reproduce: 1. Open Base 2. Connect to an existing database 3. Chouse MS Access 4. Select the MS Access file Actual Results: It shows the error: SQL Status: HY000 The connection could not be created. Perhaps the necessary data provider is not installed. Expected Results: It gives an the error abouve Reproducible: Always User Profile Reset: No Additional Info: It should connect to MS Access database
Jean-Pierre: thought you might be interested in this one since it concerns Access.
Hello, Thanks for reporting this issue. Does it crash with any MS Access database or with a specific one ? if so, could you please attach it ?
It crashs with MS Access 2007 and 2010.
[Automated Action] NeedInfo-To-Unconfirmed
@jmueller : please provide your OS and version number, and whether or not you are using a 64bit or 32bit version of LibreOffice
I'm using LibreOffice 7.0.1.2 (x64), Access 2010, Windows 10 Vers. 2004.
@jmueller : thanks for te version and bit info. The error message indicates that you need the required data provider. From memory, if you have 64bit versions of MS-Office applications installed on your machine, then you need the redistributable database access engine (DAE) components, in their latest iteration (I could only find a downloadable file dating back to 2016). If however, you have 32bit MS Office applications installed, then you will need the 32bit redistributable database access engine (DAE) components. The problem is that you apparently can't mix 64bit DAE with 32bit office applications (including LO), nor vice-versa (64bit LO) with 32bit DAE. Do you know what bit type the MS Access file is ? That will determine what kind of provider you need. There have also been reports that MS Access files created with Office365 are not readable by LO, no matter which bit-type or DAE is installed.
Hi Alex, thanks for this infos. I have installed AccessDatabaseEngine_X64. Now it works but not yet accurately. LibreOffice incurs only the tables from the Access data but not the form and not the reports. Cao Joerg
(In reply to jmueller_dw from comment #8) > Hi Alex, thanks for this infos. > I have installed AccessDatabaseEngine_X64. > Now it works but not yet accurately. > LibreOffice incurs only the tables from the Access data but not the form and > not the reports. > Cao > Joerg This is normal, LibreOffice has never been able to directly import Forms or Reports from an Access database file. LibreOffice now includes a Basic module called Access2Base that may be of use to you when migrating your Access database to a LibreOffice embedded database: http://www.access2base.com/access2base.html Additionally, there is a separate helper program called UCanAccess: http://ucanaccess.sourceforge.net/site.html which uses JDBC to read/write to Access database files. This can be used as a bridge between LibreOffice and the Access file instead of the DAE provided by Microsoft.
Marked as WFM because initial issue resolved.