

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
