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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
