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 <martin@address-in-sig.invalid>
Newsgroups: comp.lang.java.programmer
Subject: Re: Accessing Access database files
Date: Tue, 1 Jul 2014 17:29:14 +0000 (UTC)
Organization: A noiseless patient Spider
Lines: 50
Message-ID: <lour5a$a4g$3@dont-email.me>
References: <lounj9$a4g$2@dont-email.me> <loup66$93b$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Tue, 1 Jul 2014 17:29:14 +0000 (UTC)
Injection-Info: mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="10384"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/OUZQlvAP0H8HipbPvMCqyh1Qy8yC/RmA="
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock: sha1:bxk4BggvbuiggGtJMiv4BtyiYDQ=
Xref: csiph.com comp.lang.java.programmer:28888

On Tue, 01 Jul 2014 09:55:30 -0700, markspace wrote:

> On 7/1/2014 9:28 AM, 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 haven't tried this myself, but Stack Overflow says:
> 
> "You can use JDBC-ODBC bridge by calling:
> 
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
> 
> Then you can use JDBC database URL in form:
> 
> jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\Nwind.mdb
> 
> or if you configure your database in ODBC manager you can use its alias:
> 
> jdbc:odbc:northwind
> 
> "
> 
> You might need an older copy of the JDK because the driver was removed
> in JDK 8.  You can find drivers in a couple of places:
> 
> http://jackcess.sourceforge.net/
> http://ucanaccess.sourceforge.net/site.html

Does this stuff work without a copy of the Access software?
I'm puzzled because EasySoft makes a big fuss about leaving the .mdb file 
on the PC its always lived on, but I have the .mdb files I'd like to look 
at already on my Linux box. 

What this is about: I'm in the process of taking over the Roster Manager 
role for my gliding club. The task is primarily concerned with looking 
after the rosters database. There is currently no ERD for it, so it would 
be nice if I could use the jsql tool to look at the schema by accessing 
the .mdb file.


-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |