Trying to open MDB file (MS Access) in Base 25.2.6.2 according to this tutorial:
https://wiki.documentfoundation.org/Faq/Base/How_to_connect_to_a_Microsoft_Access_database/cs
But it gives me an error in the step “JDBC driver class”, when I type “net.ucanaccess.jdbc.UcanloadDriver” there. All the steps before made successfully.
Any suggestion?
You have downloaded ucanaccess from UCanAccess-A Pure Java JDBC Driver for Access?
You have unzipped and found the file ucanaccess-5.0.1.jar, also ucanload.jar?
.
ucanload has to be added in the class path for Java.
.
In the connection for Access files for JDBC-connection should be added
jdbc:ucanaccess:///home/<path_or_alias>
(your special path to the *.mdb-file)
Driver will be net.ucanaccess.jdbc.UcanloadDriver
.
This information for the driver could be found when unzipping ucanaccess-5.0.1.jar and looking in META-INF → services → java.sql.Driver
Yes, I’ve made all the steps mentioned in the wiki article.
I’m using Ubuntu 25.04.
Which version of LO did you install?
Does it recognize Java?
What’s the error message you get? Append a screenshot.
This isn’t an answer to the original post. So pleas add comments instead of “answers”.
Again the question: Does your version of LibreOffice recognize Java (Tools → Options → LibreOffice → Advanced).
If driver class couldn’t be loaded it is a problem of Java together with ucanaccess you added in classpath of Java by ucanload - see Tools → Options → LibreOffice → Advanced → Class Path
Here a screenshot of ucanload and ucanaccess: ucaload will load ucanaccess:
In the background of your screenshot: Java “Ubuntu Version 21.0.8” isn’t choosen. Will be choosen here automatically, but seems it hasen’t been choosen autoamtically under Ubuntu. System here is OpenSuSE.
.
In the front: I assigned a archive: “ucanload.jar” - but might be you assigned a folder and it will work the same…
Thanks for your affort, but I’m giving it in. Until Base is working with MS Access files natively like Writer with DOC, it’s worthless. Escaping through VirtualBox in Linux.
This will never happen. Access contains a GUI and also a database. You could connect to this database with UCanAccess to get your data. Better you copy the data in a database you could use with direct connections. For professionell use this might be MariaDB or PostgreSQL (both supported with direct connections from Base). For private use you could use the internal databases.
Why should anybody try to create a native connection to a closed source database system?
For the same reason somebody created Ucanaccess in java. And as this source is available, the next step should be easier. But we all know: There are not many developers with knowledge of database-drivers and free capacity…
.
The second problem will come, when users realize the difference between “accessing data/tables” and “just open my Access-db with all forms” (and most likely the attached macros).
Then MS Access is worthless too. Access can not open any files other than its own types (mdb, accdb). When using Access with a third-party database, you connect an Access document to the database through some adequate database driver. Same with LO Base.
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 4; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Windows 11 Pro and a noob here–but I came here to find out how import data from Calc to Baser. I haven’t found the answer yet–I just now found I can import MS Office 2000 mdb files into LO 25.8 Base. Some changes need to be made the column type & width–but this a giant step forward. Not sure ab out LinuxMint22.2 yet.
hth