Ask Your Question
0

can't open access database in base

asked 2018-08-09 21:22:53 +0200

anthony718 gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-08-10 00:53:30 +0200

Ratslinger gravatar image

updated 2018-08-10 01:11:00 +0200

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).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-09 21:22:53 +0200

Seen: 113 times

Last updated: Aug 10