Yes, we can use the UCanAccess JDBC driver to connect to Access databases (.mdb and .accdb) in LibreOffice Base. Here's how I did it on a clean install of Ubuntu 14.04 LTS.
Important Note: These instructions apply to UCanAccess version 3.0.1 and later. Before proceeding, verify that you are using the latest version of UCanAccess (available here).
First, I installed LibreOffice Base itself
sudo apt-get install libreoffice-base
Then I downloaded UCanAccess and unzipped it into the folder
I launched LibreOffice (not Base, just LibreOffice itself)
and chose Tools > Options
On the Advanced tab I clicked the "Class Path..." button
and then added the following JAR file using the "Add Archive..." button:
Note that this is ucanload.jar in the loader/ subfolder, not "ucanaccess-x.y.z.jar” in the UCanAccess home folder.
After saving the change and returning to the "Advanced” tab, I clicked the "Parameters...” button
and assigned the following Java start parameter. It uses the
-D switch to assign a system parameter named
UCANACCESS_HOME that points to the folder where UCanAccess was extracted:
Note that you must close and re-open all LibreOffice (or OpenOffice.org) components for the new "Class Path...” and "Parameters...” values to take effect. That includes any "quick start” features or other related processes. (If you want to play it safe, simply restart your machine.)
I launched LibreOffice Base, and in Step 1 of the wizard I chose "Connect to an existing database (JDBC)"
The Access file I wanted to manipulate was named "uca301demo.accdb" in my Documents folder, so in Step 2 the "Datasource URL" was
and the "JDBC driver class" was
In Step 3, I left the "User name" field empty and just clicked "Next >>".
In Step 4, I saved the LibreOffice Base database as "accdbTest.odb" in my Documents folder.
When the wizard completed it opened my LibreOffice database and I could see the tables and saved queries in the .accdb file