Drew Jensen wrote:
Andrew Sharp wrote:
Hi Kevin,
See this screendump:
http://homepage.ntlworld.com/andrew.sharp3/LFS/NoAccess.jpg
I see that some linux versions come with a working MSAccess
connection, such as Mandriva 2007, but the default download from
the OOo website isn't among them. See attached jpeg for snapshot of
available database types to me.
Andrew Sharp wrote:
Hi all,
Is there a Microsoft Access driver in RPM format for OOo-2.3.0 as
the linux version doesn't come with Access support?
I have to install OOo converting the rpms into tarballs and then
extracting them, which gives a working system, but this means
Access support isn't included.
The Windows version of OOo-2.3 works fine with Access databases. I
could use KOffice Kexi, but I am trying to wean myself of KDE!
Regards,
Andrew Sharp
Hi Andrew,
True, some Linux Distributions of OpenOffice.org where including MS
Access as a valid connection type via mdbTools - AFAIK the last
release of mdbTools was 0,6pl back around June 2004. The quality of
this driver was not considered reliable enough for production work -
therefore many ( most ) linux distributers removed this support from
OpenOffice.org - it never was part of the Vanilla release available at
the OpenOffice.org download mirrors.
There are some commercial ODBC drivers available for Unix / Linux that
may support MS Access Jet databases, but I have never tried one.
Conceivably OpenOffice.org could be used with one of these.
As for Kexi - again I have not tried the very latest release but when
last I did their support for MS Access was to perform a full import of
the tables and this was flawed with most, if not all, data types being
converted and imported to the SQLLight database as type varchar -
hardly what I would call solid support.
What I tell folks is to use MS Access under Windows and export the
tables to csv files then move these to linux or better yet install a
copy of OpenOffice.org under Windows transfer the tables from MS
Access to Base and just open the Base file under Linux..
Not the answer you are looking for I know.
Drew
Sorry for following up on my own message - but
Just so this is not misunderstood - you do not need the full MS Access
application under windows to do this transfer. Only a working copy of MS
Windows and a ODBC or ADO driver for MS Jet4 - if you don't have the
later they are available free from the MS website.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
