Thanks Gord Thompson, you helped me a lot. When the wizard completed it opened my LibreOffice database and I could see the tables in the. In Step 4, I saved the LibreOffice Base database as “accdbTest.odb” in my Documents folder. In Step 3, I left the “User name” field empty and just clicked “Next >”. 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/abrar/Downloads/baseTest.accdbĪnd the “JDBC driver class” was Then I launched LibreOffice Base, and in Step 1 of the wizard I chose “Connect to an existing database (JDBC)” Note that you must close and re-open LibreOffice for the new Class Path values to take effect. home/abrar/Downloads/UCanAccess-2.0.9.5-bin/lib/hsqldb.jar

home/abrar/Downloads/UCanAccess-2.0.9.5-bin/lib/commons-lang-2.6.jar On the Advanced tab I clicked the “Class Path…” buttonĪnd then added the following five (5) JAR files using the “Add Archive…” button: /home/abrar/Downloads/UCanAccess-2.0.9.5-bin/ucanaccess-2.0.9.5.jar I launched LibreOffice (not Base, just LibreOffice itself) Then I downloaded UCanAccess to my Downloads folder and unzipped it. Here’s how I did it on a clean install of Ubuntu 14.04 LTS.įirst, I installed LibreOffice Base itself sudo apt-get install libreoffice-base We can use the UCanAccess JDBC driver to connect to Access databases (.mdb and. LibreOffice Base has a host of handy features, including cross-database support for multi-user databases such as MySQL, Adabas D, Microsoft Access.

Libreoffice access database