Ask Your Question
1

Found method in Linux to read MS Access mdb or accdb tables into LibreOffice Base

asked 2019-07-09 05:53:44 +0200

dataguy gravatar image

I found a method in KDE Neon, based on Ubuntu Linux, to read MS Access mdb or accdb files with tables into LibreOffice Base after trying lots of other options. The step by step guide is here: link:[https://tahsinabrar.com/open-a-microsoft-access-accdb-file-in-ubuntu/]

If anyone else has success, please share your method. As far as I know you cannot import the reports or other aspects, unfortunately.

edit retag flag offensive close merge delete

Comments

Hello,

Been using that method for years now. Have many posts here regarding its installation. Even have a post to use it in Windows (step-by-step set-up).

Ratslinger gravatar imageRatslinger ( 2019-07-09 05:59:22 +0200 )edit

@Ratslinger, then please explain to the OP, where he can find this information. Or did you just forget to link?

ebot gravatar imageebot ( 2019-07-09 10:17:21 +0200 )edit

@ebot,

I saw no need for any link as it is just a duplication of the process OP has already given a link to. It is like the JAVA question (that one answered personally 100 x's or more). It is not difficult to find with a search.

For the sake of the Windows reference, here is the post -> mdb files not loading to base.

It also refers to using in Linux and a link to the home page of UCanAccess on SourceForge.

Ratslinger gravatar imageRatslinger ( 2019-07-09 17:51:45 +0200 )edit

@Ratslinger , ahh, ok.

ebot gravatar imageebot ( 2019-07-09 18:36:16 +0200 )edit

Thanks for the link so future folks have the whole bundle of help. I had found and bookmarked Ratslinger's earlier solution he put in the post about 1 1/2 years ago, and am sorry I did not pursue it at the time when I was deep in the weeds with Wine and ODBC, etc. Just after another failed attempt, I took a look at the solution at tahsinabrar.com from over 4 years ago. What drew me to it was the screen shots, so I was willing to try one more thing....

Since I prefer LO I am glad to be here and hope to use Base more. Thank you so much.

dataguy gravatar imagedataguy ( 2019-07-09 18:57:27 +0200 )edit

NOTE TO ALL READING THIS POST:

I would be very careful with the instructions provided in the "tahsinabrar.com" link in the posted question. Placing "hsqldb.jar" into a class path is dangerous! Could damage Base files. Have gone through that years ago and it is not easy to fix.

Personally I would ignore that post completely!

Ratslinger gravatar imageRatslinger ( 2019-07-10 01:48:50 +0200 )edit

I trust @Ratslinger's opinion on the usefulness of the method referred in the original post (not using Base myself, I have no experience myself); but still I feel that @Ratslinger is too harsh on this. Personally I have upvoted the post, not because I suppose it to be perfectly correct, but because it's posted here in the best spirit of sharing own gained knowledge and experience. If only more people felt like @dataguy and shared more here!..

An advise to OP: since you are able to edit your own post, I urge you to try the advises mentioned here, and edit your post to become a good source of best available information on the topic. Thanks!

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-10 03:13:32 +0200 )edit

Can't imagine not being emphatic when there is probable damage to files if instructions were followed.

I'm finished with it all!

Ratslinger gravatar imageRatslinger ( 2019-07-10 03:54:40 +0200 )edit

@Ratslinger, I haven't seen you in awhile. Before that you have been a foundation rock here! Are you ok?

EasyTrieve gravatar imageEasyTrieve ( 2019-08-12 02:20:26 +0200 )edit

@EasyTrieve Didn't you read the comment above?

BTW - your last answer is incorrect (re:Document Info). Edit the form, from menu - File ->Properties. This alleviates all your intricate bash stuff!

Ratslinger gravatar imageRatslinger ( 2019-08-12 02:35:32 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-10 02:21:49 +0200

Ratslinger gravatar image

Hello,

After a more careful reading to linked post in the question, I advise all not to follow those instructions. They can cause damage to Base files - those using HSQLDB embedded.

Instead refer to my answer here -> Importing MS Access tables into Base 5.1.6.2, No option works. Using Linux Mint..

It contains links to UCanAccess connector and the lint to the post with correct installation - AskUbuntu.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-09 05:53:44 +0200

Seen: 91 times

Last updated: Jul 10