Results 1 to 5 of 5
  1. #1
    Doctor Cactus is offline Member
    Join Date
    Oct 2008
    Posts
    63
    Rep Power
    0

    Default MS Access with Java

    I am creating a Java application. Is there a simple way to read and write data to an MS Access database? All I have seen so far is stuff about JDBC/ODBC.

    Help is much appreciated.

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    That's the one that is normally used.

    Otherwise you can try Jackcess (Google for that), but AFAIK, that is not JDBC and is fairly limited. Otherwise Google for "Type 4 JDBC Driver MS Access". There is only one that I know (from HXTT I believe the company name is), but it is not free.

  3. #3
    Eku
    Eku is offline Senior Member
    Join Date
    May 2008
    Location
    Makati, Philippines
    Posts
    234
    Rep Power
    7

    Default

    there are three ways to connect to MSAccess and i think the driver for that is already build in the JDK (i'll check on that) the name of the driver is JDBC-ODBC bridge.

    3 ways to connect.
    1. using ODBC with MS Access installed
    2. using ODBC without MS Access installed
    3. plain old direct connection to the file without any setting in the ODBC

    About writing and saving data, it is much like SQL commands or you can use preparedstatement and just use batch processing. there are many ways ^_^ Just look for the one that suit your needs =)
    Mind only knows what lies near the heart, it alone sees the depth of the soul.

  4. #4
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Those are all simply JDBC-ODBC Bridge uses.

    There are other ways. Check out Jackcess. And, like I said, there is also a Type 4 JDBC Driver for Access, although it is not free.

  5. #5
    Eku
    Eku is offline Senior Member
    Join Date
    May 2008
    Location
    Makati, Philippines
    Posts
    234
    Rep Power
    7

    Default

    Thanks for the info masijade. i'll check that.
    Mind only knows what lies near the heart, it alone sees the depth of the soul.

Similar Threads

  1. Replies: 22
    Last Post: 04-09-2011, 04:59 AM
  2. Help with Java and MS access
    By lemurian in forum New To Java
    Replies: 1
    Last Post: 04-30-2008, 01:46 PM
  3. Replies: 1
    Last Post: 03-13-2008, 02:36 PM
  4. Replies: 1
    Last Post: 08-07-2007, 07:51 AM
  5. How to access system calls in java
    By Albert in forum New To Java
    Replies: 1
    Last Post: 07-13-2007, 03:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •