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

Ali Habiby
  • 53

1 Answers1

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?

Community
  • 1
Gord Thompson
  • 1,040