Can't open access database in base

Hello,

I am trying to open an .accdb file in base, however when I open the base database wizard and choose the “connect an existing database” radio button, Access is not listed as one of the options. I have seen several videos where “Access” is listed in the list box. I am currently using libreoffice 6.1, perhaps Access support was available in an older version and no longer supported? If so would I have to download an older version that does support it (if so which version?), covert the .accdb file into an .odf file and then work on it in my current version of base? Any insight would be much appreciated.

thanks,

Anthony

MS Access opens mdb and accdb files only.
LibreOffice opens odb files only.
An Access document may embed a native JET database.
A Base document may embed a HSQL or Firebird database.
Both applications can be connected to a wide variety of different database backends.
You connect an Access document to a MySQL server.
You connect an Access document to a collection of dBase files.
You connect a Base document to an MS Access document.

Hello @anthony718,

Since you have not provided which OS you are using (seems like Linux) here are two choices:

For Linux see my answer in this post → Importing MS Access tables into Base 5.1.6.2, No option works. Using Linux Mint. (and link within). Just re-tested this with LO v6.1.0.3 on Mint 18.3 and the link seems to be missing one step. After adding the Class Path, you need to enter a parameter. On same Advanced screen, select Parameter button and enter:

-DUCANACCESS_HOME=/home/UCanAccess403/UCanAccess-4.0.3-bin

This line needs to be modified to provide your location (and version) of UCanAccess.

For Windows see my answer in this post → I got error “The connection to the data source “DB file name” could not be established.”. This has two possibilities (see links there).

1 Like

What about MacOs ? I have the same problem

Google lead me to

Where the “accepted solution” is at

Additional hint: To use a jdbc-cinnection you need a working java on your OS.