Important: You must close and re-open all LibreOffice (or ) components for the new 'Class Path.” value to take effect.

Note that this is ucanload.jar in the loader/ subfolder, not 'ucanaccess-x.y.z.jar” in the UCanAccess home folder. On the Advanced tab I clicked the 'Class Path.' buttonĪnd then added the following JAR file using the 'Add Archive.' button: /home/gord/Downloads/JDBC/UCanAccess/loader/ucanload.jar I launched LibreOffice (not Base, just LibreOffice itself)

Note: When unzipping the distribution file be sure to specify 'Keep directory structure' (or similar, depending on your unzip tool) so the folder structure appears as in the screenshot above. Then I downloaded UCanAccess ( bin.zip file) and unzipped it into the folder ~/Downloads/JDBC/UCanAccess One-Time Setupįirst, I installed LibreOffice Base sudo apt-get install libreoffice-base Here's how I did it on a clean install of Ubuntu 20.04 LTS. We can use the UCanAccess JDBC driver to connect to Access databases (.mdb and. Open Access database (accdb) ubuntu 20.04 Libreoffice Base

Libreoffice mdb