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

this is some info i found at the openoffice.org website...

http://www.openoffice.org/FAQs/ms-access.pdf

but i think you need a windows computer to do that...

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.

http://www.oooforum.org/forum/viewtopic.phtml?t=75155

http://www.oooforum.org/forum/viewtopic.phtml?t=41006

http://www.oooforum.org/forum/viewtopic.phtml?t=39816

Best of luck!

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.

http://sourceforge.net/projects/mdbtools
http://dba.openoffice.org/drivers/mdb/index.html
http://solyaris.wordpress.com/2007/0...iles-on-linux/

These are pages that will be of help to you