Description: With Libreoffice Base 5.3.3, I cannot open the mdb (attached). OpenOffice 3.4 can manage it successfully. Steps to Reproduce: 1. Open mdb 2. doesn't work Actual Results: doesn't work Expected Results: should open as in OpenOffice 3.4 Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
Created attachment 139356 [details] MDB with problem
I've attached the MDB for testing purpose.
Hi luca m., I open your file with the next steps: Open LibreOffice, next Choose Base Database Into Database Wizard, tick Connect to an existing database and select Microsoft Access in the dropdown list beneath, validate by Next. Browse to select your file, validate by Next and Finish. Do you open it this way, else describe where this doesn't work? Tried with LO 5.4.4.2 Build ID: 2524958677847fb3bb44820e40380acbe820f960 Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; Locale : fr-FR (fr_FR); Calc: CL
(In reply to Jacques Guilleron from comment #3) > Hi luca m., > > I open your file with the next steps: > Open LibreOffice, next Choose Base Database > Into Database Wizard, tick Connect to an existing database and select > Microsoft Access in the dropdown list beneath, validate by Next. > Browse to select your file, validate by Next and Finish. > > Do you open it this way, else describe where this doesn't work? Yes, I'm opening in your way. Using LibreOffice 5.4.3. After doing your steps, LibreOffice reports me these TWO errors: - SQL State: HY000 - The connection could not be created. May be the necessary data provider is not installed - Unable to create link to the data source
I also tried to install "Microsoft Access Database Engine 2010 Redistributable". No lucky.
You have "Linux" selected. Is that true, or do you can work on Windows? Do you have got a 64-bit LibreOffice version? If yes, please try a 32-bit version. The 32-bit version works for me up to the current developer version 6.1 on Windows 10. In the 64-bit version the connection to the needed "Jet" DB-provider is missing.
I luca m., Regina, I changed Hardware to Linux following the first comment. What is said next makes think the inverse. Please precise if you are using Windows and which version. Thank you.
(In reply to Jacques Guilleron from comment #7) > I luca m., Regina, > > I changed Hardware to Linux following the first comment. What is said next > makes think the inverse. Please precise if you are using Windows and which > version. > Thank you. You're right :-) LibreOffice 5.4.3 running on Windows 7 Professional.
(In reply to Regina Henschel from comment #6) > Do you have got a 64-bit LibreOffice version? Yes. > If yes, please try a 32-bit > version. The 32-bit version works for me up to the current developer version > 6.1 on Windows 10. In the 64-bit version the connection to the needed "Jet" > DB-provider is missing. Now I've tried: with Libreoffice 32-bit, I can connect to the Access mdb file and view the tables. I wonder if the 64-bit Jet libraries exist, so we can integrate them in Libreoffice 64.bit?
(In reply to luca m. from comment #9) > (In reply to Regina Henschel from comment #6) > > Do you have got a 64-bit LibreOffice version? > > Yes. > > > If yes, please try a 32-bit > > version. The 32-bit version works for me up to the current developer version > > 6.1 on Windows 10. In the 64-bit version the connection to the needed "Jet" > > DB-provider is missing. > > Now I've tried: with Libreoffice 32-bit, I can connect to the Access mdb > file and view the tables. > Closing as RESOLVED WORKSFORME