Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Martin Gregorie Newsgroups: comp.lang.java.programmer Subject: Re: Accessing Access database files Date: Wed, 2 Jul 2014 22:39:49 +0000 (UTC) Organization: A noiseless patient Spider Lines: 29 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Wed, 2 Jul 2014 22:39:49 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="3537"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+gd7gOsCGO9J+U0RjGoLhR9qB3fYPOvZI=" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:POkKimNhXJWMUPeqSjbKA6TqpPE= Xref: csiph.com comp.lang.java.programmer:28922 On Wed, 02 Jul 2014 17:08:56 -0400, Jeff Higgins wrote: > On 07/01/2014 12:28 PM, Martin Gregorie wrote: >> Is there a JDBC driver or non-JDBC class library that would give a Java >> program read/write access to the tables and schema in a MS Access >> database? >> >> I don't need to update the database, just examine the schema and table >> contents. I don't have a copy od the Access software and nowhere to run >> it because all my computers run Linux. >> >> > I'm pretty sure Open Office will open Access databases? > Yes, its known to do that, but the usual run of ODBC/JDBC drivers almost certainly expect the JET database server to be involved. I don't have JET or an OS it would run on, hence my interest in using UCanAccess. UCanAccess is a JDBC driver written in Java that incorporates Java class libraries to give it direct access to the Access database files and an SQL engine. Because if this it has been shown to let Libre Office and Open Office, running under Linux, read and write Access database files installed locally on the same Linux box. This is exactly what I need. -- martin@ | Martin Gregorie gregorie. | Essex, UK org |