HowTo: Open a Microsoft Access .accdb file in Ubuntu

Recently, I need to run a .accdb file in Ubuntu. I use ubuntu 14.04 LTS version. I tried to run with LibreOffice Base. But failed. And thanks to AskUbuntu. I got the solution from there.


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.

First, I installed LibreOffice Base itself

sudo apt-get install libreoffice-base

Then I downloaded UCanAccess to my Downloads folder and unzipped it.

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 five (5) JAR files using the “Add Archive…” button:



Note that you must close and re-open LibreOffice for the new Class Path values to take effect.

Then 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 “baseTest.accdb” in my Downloads 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 in the .accdb file



This solution is collected from here. Thanks Gord Thompson, you helped me a lot.


  1. Brilliant, and still working in 2021 on libreoffice (some menus /screenshots have changed, but nothing important) !

  2. No luck. The driver (5.0.1) hangs trying open MS access databases. Eventually it reports that the database cannot be opened probably because of a defective driver.

    Ubuntu, LibreBase have never really worked for me anyway.

    Back to Windows :-(

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.