Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 10-18-2008, 05:43 AM   #1
Registered: Sep 2007
Location: Folsom, California
Distribution: Debian 4.0 (Etch), Debian 5.0 (Lenny), Ubuntu 8.04
Posts: 301

Rep: Reputation: 32
Linux Open Office and MS Access .mdb files

I'm on the verge of a mental melt-down.

I want to open a MS Access (.mdb) file in Open Office under linux. I've found several web sites talking about using an ODBC and blah blah blah... none of it I understand.

I guess all I want to know is this: Can a person open, obtain information from, export, etc information from a MS Access (Office 97) .mdb file?

I want to get the information off in whatever way it the fastest/easiest so I can recreate the database with minimal effort in mysql.

Everytime I open it in Open Office and click on Tables Open Office crashes (I haven't seen a crash in linux in forever - it has to be MS's fault).

Am I doing something wrong, or am I expecting Open Office to do something that it simply cannot?

P.S. I've tried mdbtools also - it crashes as well with the error: "Segmentation fault".

Last edited by checkmate3001; 10-18-2008 at 05:45 AM. Reason: added info about mdbtools
Old 10-18-2008, 06:57 AM   #2
Registered: Aug 2007
Distribution: openSUSE 12.1
Posts: 96

Rep: Reputation: 24
this is some info i found at the website...

but i think you need a windows computer to do that...
Old 10-18-2008, 08:15 AM   #3
Registered: Mar 2007
Location: United Kingdom
Distribution: Mint, OpenSUSE,Dream
Posts: 68

Rep: Reputation: 17
.mdb into OOBase

You'll run into problems if your .mdb file contains forms and reports. These use libraries that are not supported by OOB.

These links might prove helpful.

Best of luck!
Old 10-18-2008, 05:27 PM   #4
Registered: Sep 2007
Location: Folsom, California
Distribution: Debian 4.0 (Etch), Debian 5.0 (Lenny), Ubuntu 8.04
Posts: 301

Original Poster
Rep: Reputation: 32
Thank you two for your help. However, I have come to the conclusion that the only (and most reliable) way to recreate the database for use on linux with mysql is to either export everything to text (.csv) and import that to mysql or just rewrite everything from scratch.
Old 10-18-2008, 08:07 PM   #5
Registered: Nov 2002
Location: Kent, England
Distribution: Debian Testing
Posts: 19,191
Blog Entries: 4

Rep: Reputation: 464Reputation: 464Reputation: 464Reputation: 464Reputation: 464

These are pages that will be of help to you


access, microsoft, office, open

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Samba 3, MS Access mdb files failures Normanjr Linux - Server 1 03-27-2008 01:38 AM
Open Office 2.0.1 Base Import secured MDB k.king Linux - Software 0 01-19-2006 03:52 PM
Using open office from Linux on Windows partition files munichtexan Linux - Software 1 12-07-2005 12:27 PM
NFS and MS Access MDB Files ja_nch Linux - Networking 1 09-20-2003 02:53 PM
how to access microsoft mdb in redhat linux 8 kjsubbu Linux - Software 8 06-02-2003 05:26 PM

All times are GMT -5. The time now is 09:48 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration