Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #28885

Re: Accessing Access database files

From markspace <markspace@nospam.nospam>
Newsgroups comp.lang.java.programmer
Subject Re: Accessing Access database files
Date 2014-07-01 09:55 -0700
Organization A noiseless patient Spider
Message-ID <loup66$93b$1@dont-email.me> (permalink)
References <lounj9$a4g$2@dont-email.me>

Show all headers | View raw

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

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 16:28 +0000
  Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 09:55 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 17:29 +0000
    Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:49 -0400
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:03 +0000
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:06 -0400
        Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 09:48 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-03 16:31 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 22:03 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:01 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 16:42 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:45 -0400
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:47 -0400
  Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:47 -0400
    Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 20:11 -0700
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:05 -0400
  Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-02 16:57 +1000
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:20 +0000
      Re: Accessing Access database files Robert Klemme <shortcutter@googlemail.com> - 2014-07-02 20:22 +0200
  Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-02 09:40 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 21:28 +0000
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:09 -0400
  Re: Accessing Access database files Jeff Higgins <jeff@invalid.invalid> - 2014-07-02 17:08 -0400
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 22:39 +0000
  Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-05 16:28 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 08:51 +0000
      Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-06 19:01 +1000
        Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 17:11 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:17 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 19:30 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:10 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:26 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:27 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 22:37 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:06 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:45 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 17:50 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 22:34 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 19:24 -0400
    Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 11:55 -0400

csiph-web