I have a .accdb file created with Microsoft Office 2010 and I want to know if it is possible to open it with some native Ubuntu application like LibreOffice or OpenOffice, I know LibreOffice has LibreOffice Base but I can't figure out how to open or if it's even possible to open a .accdb file.

Is there any way I can open a .accdb file without Wine or VirtualBox?

up vote 12 down vote accepted

As mentioned here it says it supports Access files but if we look deeper they have only tested in LibreOffice up to Office 2007.

Since you have an Office 2010 I would suggest trying out this link since other users by the look of this have already tried.

Additionally the compatibility shown here says how good LibreOffice Base is when relating to Microsoft Access 2010. At least up to version 3.6.

There is also a question on the Ask Libreoffice site about this that mentions this link where it is said that the 2007 format is different from the 2010 so it will not work correctly in LibreOffice 3.6 or below.

My only recommendation that does not include Wine or VirtualBox would be to use MS Office 2010 to save the Access file as a 2007 version (If possible) or a MDB format. At least while LibreOffice works on improving compatibility with 2010 in general.

  • 1
    I noticed this line here: 'limited olders driver "Microsoft.Jet.OLEDB.4.0" works fine for read/write, while "Microsoft.ACE.OLEDB.12.0" driver only reads; (fdo#43187). Driver only works on Windows.' - great... – Wilf Jun 26 '14 at 18:19

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.5 and later (including version 4.x). Before proceeding, verify that you are using the latest version of UCanAccess, available here.

One-Time Setup

First, I installed LibreOffice Base

sudo apt-get install libreoffice-base

Then I downloaded UCanAccess (bin.zip file) and unzipped it into the folder



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.

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.

Important: You must close and re-open all LibreOffice (or OpenOffice.org) components for the new "Class Path...” value to take effect. That includes any "quick start” features or other related processes. (If you want to play it safe, simply restart your machine.)

Per-Database Setup

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


  • Upvoted, helped a lot, thank you so much... – Tinellus Dec 27 '14 at 11:10
  • Great work Gord. Any idea if this is using existing drivers? I'm having trouble getting this into my statistical software for importing Access Tables :) – AdamO Jun 22 '15 at 21:39
  • Brilliant! But I needed to add jackcess-2.1.4.jar and hsqldb.jar to my java class path. (I did this by putting them in jdk/jre/lib/ext) Before that I kept getting an error message saying the driver was corrupt. – Lance Holland Oct 3 '16 at 12:54
  • Woow, it works, thank you! :-) – Fernando Mertins Aug 7 '17 at 18:32

protected by Community Apr 26 '16 at 17:25

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.