

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.
