Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 3 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.

share|improve this answer
    
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 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.

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)

LibreOffice.png

and chose Tools > Options

ToolsOptions.png

On the Advanced tab I clicked the "Class Path..." button

ClassPath.png

and then added the following five (5) JAR files using the "Add Archive..." button:

/home/gord/Downloads/UCanAccess-2.0.8-bin/ucanaccess-2.0.8.jar
/home/gord/Downloads/UCanAccess-2.0.8-bin/lib/commons-lang-2.6.jar
/home/gord/Downloads/UCanAccess-2.0.8-bin/lib/commons-logging-1.1.1.jar
/home/gord/Downloads/UCanAccess-2.0.8-bin/lib/hsqldb.jar
/home/gord/Downloads/UCanAccess-2.0.8-bin/lib/jackcess-2.0.4.jar

AddArchive.png

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)"

ExistingDatabase.png

The Access file I wanted to manipulate was named "baseTest.accdb" in my Downloads folder, so in Step 2 the "Datasource URL" was

jdbc:ucanaccess:///home/gord/Downloads/baseTest.accdb

and the "JDBC driver class" was

net.ucanaccess.jdbc.UcanaccessDriver

JdbcConnection.png

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

Tables.png

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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