On 23/05/2008, at 10:58 PM, Drew Jensen wrote:
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.
Probably the most likely technology to use to migrate your MS Access
to Mac would be the ODBC connector. It is cross-platform and support
all basic data requirements, even thought it can be a little slow at
times.
Regards
Jonathon
--------------------------
Jonathon Coombes
OOo Knowledgebase:- http://mindmeld.cybersite.com.au
http://www.cybersite.com.au
http://www.training4linux.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
