Chalk it down to yet one more LO anomaly and oddity around which you have to navigate by hook or by crook.Have you got old MDB or ACCDB files from some source and now want to peep inside its data? But guess what you do not have Microsoft Access installed on your system. Furthermore, after having first opened the LO Base form I am then able to run the Python application.Īs to why this ludicrous error should arise in these circumstances in the first place, I do not yet know. I find that when I close the Python application I am then able to open the LO Base form.
Nor, being CPython, does it use Java in any way whatsoever. Interestingly, I happened to have a Python application running at the same time but, and I stress, this Python application does not use any kind of connection to any mysql database whatsoever. The form was created only minutes previously. I just encountered this message with an LO Base form which uses a MariaDB installation on Windows 10, using a JDBC connection with the mysql-connector-java-8.0.28.jar connector. Such statements should be avoided as they are clearly very difficult to prove except with rigorous analysis of all other situations, which is clear was not done and in practical terms cannot be done. This is NOT (as per chosen answer) "specific to distributions like Linux Mint that install LibreOffice Base by default".
In the text box (as in the screenshot above). We need to have just ucanaccess:///home/gord/Documents/Database1.accdb Then apparently Base will try to use jdbc:jdbc:ucanaccess:///home/gord/Documents/Database1.accdbĪnd that won't work. So if the textbox contains jdbc:ucanaccess:///home/gord/Documents/Database1.accdb When Base opens, chooseĪnd notice that the "Database URL" text box has "jdbc:" in front of it. It looks like the setup instructions on Ask Ubuntu may need to be tweaked. I was able to reproduce your issue with LibreOffice 6.4.6.2 on Xubuntu 20.04. For Linux Mint that would be sudo apt remove libhsqldb1.8.0-java To fix that, remove LibreOffice's copy of HSQLDB. Presumably in order to enable embedded HSQLDB databases they also install a rather old version of HSQLDB which conflicts with UCanAccess. It appears that this issue is specific to distributions like Linux Mint that install LibreOffice Base by default.
0 kommentar(er)
