Open accdb file in Linux LO

LibreOffice 50(Build:2)

I have an MS Access accdb file.

  1. Start LO
  2. Choose Base Database/
  3. Select Database
  4. Connect to Existing Database

In the options dropdown there is no Access database.

How can I configure LO to use this Access database?

Precondition: Base and Java installed so you can open any JDBC database such as PowerFilter.odb (85.5 KB)

  1. Download and extract UCanAccess-A Pure Java JDBC Driver for Access
  2. menu:Tools>Options>Advanced [Class Path…] and point to the file “ucanload.jar”.
  3. Restart LibreOiffice
  4. Create a new database document connected to an existing database of type “JDBC”
    3.1. URL: ucanaccess:///path/to/your/database.accdb
    3.2. JDBC driver class: net.ucanaccess.jdbc.UcanloadDriver
1 Like

Perfect. Thank you.