5

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

1
  • * I have updated to latest base version and also to Ubuntu 14.04. Still cannot see option to view/open MDB databases. Tried uninstall and reinstall LibreOffice + mdbtools as well. But no success
    – Ali Habiby
    Apr 22, 2014 at 15:15

1 Answer 1

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?

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .