I created a database originally in Microsoft Access, then installed Open Office 2.2 on a PC. I have now changed platforms to Mac (OS X 10.5.4), and am running a BootCamp Windows partition on the Mac. I can open the database (saved in .mdb format) as a Table using sbase in the Windows partition. After installing Open Office 2.4 on the Mac, and copying the file to the Mac, I cannot access this database. Anyone know how to do this?
P.S. Cannot re-save file in .odb, or other format to permit access. The Mac version of Open Office defaults to Writer, and I cannot directly open the database application.
Database Files
Database Files
OOo 2.4.X on Mac OSx Leopard + Windows XP
Re: Database Files
OOo on Mac and on Linux dont't has any driver for MSA mdb files. I found some info on NeoOffice (OOo derivate for Mac) wiki for MSA drivers, it says abot some ODBC drivers which can solve your problem, but it is not free. All other part of this wiki is good for OOo, too.
You just use Base as front end to mdb file. So the possible solution copy all your data from mdb file to native HSQDB odb and that file copy to Mac.
Open your existing file in win, connected to mdb, create new empty odb file, drag table from old file to new into table area, wizard will start and copy all data into new file. If table not contain primary key create it during wizard. Copy all tables save odb. Close OOo and quick starter. Copy file to Mac.
You just use Base as front end to mdb file. So the possible solution copy all your data from mdb file to native HSQDB odb and that file copy to Mac.
Open your existing file in win, connected to mdb, create new empty odb file, drag table from old file to new into table area, wizard will start and copy all data into new file. If table not contain primary key create it during wizard. Copy all tables save odb. Close OOo and quick starter. Copy file to Mac.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
Re: Database Files
Just curious... are there any plans to add such drivers to OOo for Mac in the future?
Re: Database Files
These mdb drivers on win is based on OS capabilities and not OOo developed.
That means if these will be on Mac it will be used, but I'm not sure that will happened in near or far future.
That means if these will be on Mac it will be used, but I'm not sure that will happened in near or far future.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
Re: Database Files
The answer to the question about development of read/write capability of MDB files on OOo for Mac will depend on someone volunteering to develop it or rebuild it so that it works. This is the same with regard to most of the specific database driver stuff for platforms other than Windows and Linux. As an example, one can cite the absence (at present) of a native SDBC postgresql driver for the Mac OOo port, a native SDBC MySQL driver, a native SQLite driver, etc, etc.