Ask Your Question
1

Opening Access Database using ODBC

asked 2014-12-16 15:32:50 +0200

updated 2018-10-29 22:24:51 +0200

EasyTrieve gravatar image

How do I open an MS Access database (*.mdb) using ODBC from LibreOffice?

I'm running Apple's Yosemite OS and the current version of LibreOffice.

edit retag flag offensive close merge delete

Comments

I edited your Q a bit to try to clarify it. Please check it and re-edit if this is inaccurate.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-29 22:24:15 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-29 18:40:02 +0200

LKeithJordan gravatar image

Try reading this article: https://forum.openoffice.org/en/forum...

Substitute "LibreOffice" for "OpenOffice." In the most current versions of LO, substitute "Firebird" for "HSQLDB."

There may be some other differences here are there, but it appears this article is enough on point it should get you started.

Hope this helps.

Please click the check mark beside the response that best answers your question.

edit flag offensive delete link more

Comments

1

@LKeithJordan Just for your information. The link you mention has nothing to do with opening an Access file (original question). The article instead is discussing the separation of the data from the .odb. Additionally, your mention of substituting Firebird for HSQLDB is not correct. Firebird has an entirely different structure & in the case of the link would need a different methodology.

Ratslinger gravatar imageRatslinger ( 2018-10-29 19:31:33 +0200 )edit

Hi @Ratslinger. On your first assertion, I respectfully disagree.

In the link I referenced, the OP indicated he had a split database in Access. One of his questions was "possible to link tables in an OpenOffice database with ODBC or another connection protocol." The reply discusses using ODBC and also indicates "you can still use MS Access database file with Base," so I would argue that your assertion that link "has nothing to do with opening an Access file" is incorrect.

(Continued)...

LKeithJordan gravatar imageLKeithJordan ( 2018-10-29 20:03:24 +0200 )edit

...(continued)

As for your comment concerning Firebird, perhaps I was not clear. I was not asserting that the OP substitute mere words, but that the same concepts would apply, just with a different methodology (a point on which we appear to agree).

Good to talk with you. I've been out of circulation for awhile. Trying to get back into the swing of things.

Take care.

LKeithJordan gravatar imageLKeithJordan ( 2018-10-29 20:07:56 +0200 )edit

@LKeithJordan Sorry but my comment was not specific enough. The link does mention the ability to connect to a database using ODBC (& other methods). It does not specify how(original question). The remainder of the answer is simply about HSQLDB split DB's(data separate from .odb). This has nothing in common with the Access split mentioned in the linked question-Tables in one .mdb & rest (forms & other items) in a different .mdb-not doable in Base(at least not easily). Firebird is another story.

Ratslinger gravatar imageRatslinger ( 2018-10-29 20:24:24 +0200 )edit

Actually the question above should not even reference ODBC. The real question is connecting to Access DB on a Mac. The method can be through ODBC or JDBC. In this particular case, the easiest is probably JDBC using UCANACCESS.

Ratslinger gravatar imageRatslinger ( 2018-10-29 20:29:48 +0200 )edit

@Ratslinger, after reading the original post, I looked up "Yosemite" to find it was a Mac OS -- only to promptly forget that little piece of information while searching for and reading potential solutions.

I confess a lack of experience with Macs. I yield to your experience and knowledge in this situation.

Have a great day.

LKeithJordan gravatar imageLKeithJordan ( 2018-10-29 21:41:34 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2014-12-16 15:32:50 +0200

Seen: 564 times

Last updated: Oct 29 '18