Base 4.2.1 does not display Access Database Connection option

Question

I am a relatively new user to Ubuntu. I would like to open Access database in Ubunutu to view the tables but cannot use Wine/MS Office. I have installed LibreOffice 4.2.1 alongwith base. Problem is that when trying to Connect to an Existing database, the option to use Access is not displayed.

Displayed options are JDBC, Oracle JDBC, Thunderbird Address Book, Spreadsheet, dBASE, Text, MySQL, ODBC

Libre Office version 4.2.1, mdbtools is installed.

Regards, Ali

score 3 · Accepted Answer · edited Apr 13 '17 at 12:24

3

The option to connect directly to an Access database is only available in the Windows versions of LibreOffice Base. However, it is possible to use the UCanAccess JDBC driver to give LibreOffice Base read/write access to a Microsoft Access database file (.mdb or .accdb).

For detailed instructions on how to set it up, see my answer to a similar question here:

Is it possible to open an Access 2010 database file without using Wine or VirtualBox?

edited Apr 13 '17 at 12:24

Community

1

answered Sep 07 '14 at 20:29

Gord Thompson

1,020

Thanks. I never knew that the functionality to connect to Accdb is not supported on Linux version of LibreOffice. – Ali Habiby Oct 20 '14 at 13:50

Base 4.2.1 does not display Access Database Connection option

1 Answers1