Andrewjohn Clarke wrote:
Hi,
I've downloaded the Aqua Beta version of Openoffice to see if I could open an
Access .mdb file.
And now you know.
Although the Help referred to ADO as the way to open it I saw no such option on
the Database Wizard.
That is because ADO ( Active Data Objects ) is a Microsoft technology
and not available on competitor OSs.
Ideas?
If your requirement is to have interoperability at a file sharing level,
then OpenOffice.org on a Mac-OSx (or any flavor of linux ) is not going
to work well.
On the other hand if you simply need migrate the data, then of course
you can export to something that OO.o under linux can work with. You
could export from Access to CSV files for instance, then you would need
to import in OO.o.
Under Linux, and this would be a good choice in the long run maybe, you
can use Kexi to convert an Access .mdb file ( no support for .accdb
files IIRCC and no support for going the other way back to Access ) to
SQLite3. I say long term because the OpenOffice.org SQLite driver is not
really that great yet, but is being developed further.
Other options would be to convert from Access to SQL Server if you have
it available, or MySQL. In this type of arrangement you can share data
between your Mac users and your PC users and between MSO Access and OO.o
Base users.
Probably not leaving you with a warm fuzzy feeling right now...but it
is, what it is.
Drew
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
