The connection to the data source __ could not be established

[KC11]

I have spent hours trying to get LO base to open an original MS access file.

1. Connect to an existing database
2. Select, “Finish”, name the file
3. At opening it gives me the error message: The connection to the data source “Name” could not be established.

I uninstalled, reinstalled, a couple of times the latest Libreoffice for Windows 64 bit
I installed the latest java 64 bit
Tried installing the 32 bit Libreoffice, but it doesn’t work, so I reinstalled the 64 bit
I see the Java installed listed in the Settings, Advanced menu and the radio button selected.

I was able to open it for a moment but I don’t remember what happened, closed it, never happened again in these hours of working on this. Is there a simple solution that doesn’t require downloading files or apps from other websites (other than java)?

[fpy]

Ask/Guide - How to use the Ask site - The Document Foundation Wiki #More_details

[Villeroy]

Open accdb file in Linux LO

Precondition: Base and Java installed so you can open any JDBC database such as PowerFilter.odb (85.5 KB) Download and extract UCanAccess-A Pure Java JDBC Driver for Access menu:Tools>Options>Advanced [Class Path…] and point to the file “ucanload.jar”. Restart LibreOiffice 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