How do I open my Microsoft Access database in Ubuntu 9.10?

I don't think you can, unless you open it in Access and export it in a format OpenOffice can use.

Hi Ryan,

Many thanks for your suggestion.

I will take it a try.

http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Migration_Guide/General_Differences

Hi Guys,

I already solve this problem with a solution below.

The Microsoft Access database file is here.
https://docs.google.com/leaf?id=0B1d8pwAkthqlMDM1OWRiNDItZGU1MC00OGVlLWIwODAtZmU0MzQxNzc1ZDA2&hl=en

From Microsoft Access table to csv file.
---------------------------------------------------------------------------------------------------------------------------------------------------------------
    Pick your chosen table, query, whatever.
    File -- Export...
    Using the "Save as type" drop-down arrow, choose "Text Files (*.txt;*.csv;*.tab;*.asc)"
    Give the file a different name if you want to.
    Decide if you want it to Save Formatted and if so, do you want Autostart (not sure about these options, never used them).
    Now either use the "Save All" button or "Save" button depending which you have (if the "Save All" button, you have the choice of "Save All" or Selected, I think were the options).

    Done and no other software involved.

    Of course, if it's a database with a lot of tables, etc it might take a while to do them all but at least you can do it straight out of Access itself.
---------------------------------------------------------------------------------------------------------------------------------------------------------------

From csv file to OpenOffice table solution is below

http://sheepdogguides.com/fdb/fdb1imp1.htm

The database I had converted is below.
https://docs.google.com/leaf?id=0B1d8pwAkthqlZDFiMzhlYzktZWFiNi00NjkwLWFjOWItYjNkMzQ1MDIzYmFm&hl=en

Many thanks for your helping.

Many regards,
Vincent