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

[KC11]

Thanks, this is great. I got to Test Class, which was successful, but I am not sure of your 3.1 - you have " URL: `ucanaccess:///path/to/your/database.accdb"

I dont see “URL” in the same page as “JDBC driver class:” Instead, there is “jdbc:”
Is this where I enter the file location of the database I like to open? Do I add at the beginning of the path “ucanaccess:///” or without the “///” or just the file path without this word?

Thanks!

[Wanderer]

@KC11

open? Do I add at the beginning of the path “ucanaccess:///” or without the “///” or just the file path without this word?

You could try to find path/to/your/database in the instructions and replace it with your path. The result is an URL, wich consists of a protocoll (ucanacess) and the location.

[jucasaca]

Perhaps this page How to connect to a Microsoft Access database - The Document Foundation Wiki can help you.