Ubuntu
openoffice.org package

how to open mdb files in oo

Asked by malco

 i can`t open microsoft access files in oo! I start oo database, find file, select that is microsoft access file, then oo give my to save file (save it like new document) but don`t open it!

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Magnus Malmsten (magnus-malmsten) said : 		#1

I read in the MSA-Base Faq at http://wiki.services.openoffice.org/wiki/MSA-Base_Faq that this only works in the Windows version of OO.
Because Access depends on the Microsoft Data Access Components.

The MDB Tools project at http://mdbtools.sourceforge.net/ is a effort to document the MDB file format used in Microsoft's Access database package, and to provide a set of tools and applications to make that data available on other platforms.

You could try to convert the data on a OO MS Windows installation with the Microsoft Data Access Components installed and then moving the database to Ubuntu.

Revision history for this message
Mark Howard (mh-tildemh) said : 		#2

The MDB Tools project mentioned above provides a graphical viewer for mdb files. You have to run gmdb2, then load the file, since it isn't automatically associated with *.mdb files (see https://bugs.launchpad.net/ubuntu/+source/mdbtools/+bug/37440/)

Can you help with this problem?

Provide an answer of your own, or ask malco for more information if necessary.

To post a message you must log in.