Description: i have attached a sample .accdb file which double clicks fine on access 2019 but when i try to open it with base, it fails and writer opens the file as garbled. Trying to open base and connecting to database, there is no option to connect to existing access database, it fails Steps to Reproduce: 1. double click on .accdb file. writer opens garbled text instead of base 2. open base. no option to connect to access database 3. open odbc file. says error "Could not load the program library libodbc.so or it is corrupted. The ODBC data source selection is not available." Actual Results: base should open the file but in my ubuntu instance, i am unable to even open the file which works perfectly in access 2019. Expected Results: file should work Reproducible: Always User Profile Reset: No Additional Info: Version: 6.4.5.2 Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kf5; Locale: en-IN (en_IN.UTF-8); UI-Language: en-US Calc: threaded Operating System: KDE neon 5.19 KDE Plasma Version: 5.19.4 KDE Frameworks Version: 5.72.0 Qt Version: 5.14.2 Kernel Version: 4.15.0-112-generic OS Type: 64-bit
Created attachment 163754 [details] rar file containing .accdb file
Hello Johnks, the rar file seems to be corrupted. Please, reattach it
Created attachment 163879 [details] accdb file
Created attachment 163880 [details] zip containing acdb file
My understanding was that LibreOffice can't open .accdb files on Linux. The only way to achieve this was, as far as I know, via UCanAccess : http://ucanaccess.sourceforge.net/site.html Setting as request for enhancement, nice to have, but don't hold your breath.
I think it's next to impossible that LO will make Linux driver for ACCDB, when it didn't do it in Windows, but relies on MS drivers (which don't work BTW directly nor ODBC for accdb). With this solution of UCanAccess JDBC driver nothing more should be expected. It uses Jackcess. Other solution is to export Access to CSV like https://github.com/pavlov99/mdb-export-all.