Open accdb file in Linux LO

[carnish]

LibreOffice 7.5.3.2 50(Build:2)
6.3.1-arch1-1

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?

[Villeroy]

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

[carnish]

Perfect. Thank you.