2

I try to open a access database in LibreOffice Base

First, I installed LibreOffice

sudo apt-get install libreoffice

Then I downloaded UCanAccess (http://ucanaccess.sourceforge.net/site.html) and unzipped it into the folder

~/Téléchargements/UCanAccess-3.0.7-bin

I launched LibreOffice, and chose Tools > Options. On the Advanced tab I clicked the "Class Path..." button

Options LibreOffice

and then added the following JAR file using the "Add Archive..." button:

enter image description here

I launched LibreOffice Base, and in Step 1 of the wizard I chose "Connect to an existing database (JDBC)"

enter image description here

The Access file I wanted to manipulate was named "TEST.accdb" in my Téléchargements folder (Download in french)

enter image description here

In Step 3, I left the "User name" field empty and just clicked "Next >>".

In Step 4, I saved the LibreOffice Base database as "Nouvelle base de données.odb" in my Documents folder.

When the wizard completed it opened my LibreOffice database, i have this message error :

enter image description here

I tought i should need to add a parameter in Java Start Parameter

enter image description here

But it's not work. Theye are someone have a solution ? Thanks in advance.

[EDIT 01]

I use now UCanAccess 5.0.1 and correct the link

-DUCANACCESS_HOME=///home/za/Téléchargements/UCanAccess-5.0.1.bin

But now i have a new error

enter image description here

  • 1
    C:\ sounds like a Windows-path, but you're using Ubuntu. Make sure you actually entered the correct path. – Erik A Feb 16 '21 at 14:38
  • 2
    Note also that UCanAccess 3.0.7 is a very old version. The most current version is 5.0.1 – Gord Thompson Feb 16 '21 at 14:49
  • Besides the windows-like syntax (see Erik's comment), there might also be a typo in your Java start parameter. You wrote "Téléchargementz" ending with "z", but your path is named "Téléchargements" with "s". – tohuwawohu Feb 16 '21 at 15:09
  • 1
    FYI, I just tested the instructions [here](https://askubuntu.com/a/519571/323236) with Xubuntu 20.04 and UCanAccess 5.0.1 and they still work fine. – Gord Thompson Feb 16 '21 at 15:18
  • @GordThompson i add a edit –  Feb 16 '21 at 15:32
  • "The Access file I wanted to manipulate was named "TEST.accdb" in my Documents folder" - but your connection URL does not point to your "Documents" folder, it points to your home folder. – Gord Thompson Feb 16 '21 at 15:38
  • @GordThompson sorry, i write it without thinking traduction –  Feb 16 '21 at 15:55

1 Answers1

0

There is still something wrong in the path you wrote. There are three slashes where there should be only two:

-DUCANACCESS_HOME=//home/za/Téléchargements/UCanAccess-5.0.1.bin
Mureinik
  • 3,974
  • 11
  • 28
  • 32
zello
  • 1