Results 1 to 7 of 7
  1. #1
    newbiejava is offline Senior Member
    Join Date
    Jan 2010
    Posts
    138
    Rep Power
    0

    Question Where can I download JDBC for Ms. Access ?

    Hello All,

    Where can I download JDBC for Ms. Access ?

    please advise

    Thanks & Regards

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

    Default

    There is only one Type 4.0 (I.E. Java only driver, which is not, or at least not supposed to be, a simple proxy) JDBC Driver for MS Access (by HXTT or something like that, so Google that), and is not free. You would be much better off using a different database. If it must be an "embedded" DB than look into Apache Derby (I.E. JavaDB which is distributed bundled with JDK 6).

  3. #3
    newbiejava is offline Senior Member
    Join Date
    Jan 2010
    Posts
    138
    Rep Power
    0

    Default

    Hi, I need to use portable database, could you please advise what database should I use (readable on Windows & Linux) ..

    derby is database server and it's not portable ..right? (pls correct me if I'm wrong)

    thanks & regards

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

    Default

    It can be run in server/client mode. It does not need to be, and, is most often used in "embedded" mode (i.e. not a server). And, seeing as how it is a DB that is implemented completely in Java, it is the most portable DB you're going to find, which MS Access definately is not. That you need to use it on Linux eliminates MS Access from your possibilites anyway.

  5. #5
    newbiejava is offline Senior Member
    Join Date
    Jan 2010
    Posts
    138
    Rep Power
    0

    Default

    noted with thanks, I will try derby now ;>)

  6. #6
    newbiejava is offline Senior Member
    Join Date
    Jan 2010
    Posts
    138
    Rep Power
    0

    Default

    btw, how to distribute my db? .. or I just copy the database folder?

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

    Default

    Do need to deliver actual data or just the structure? If just the structure, don't bother. Write a small set of classes that create the tables and the like, and on program start simply get a connection, use DatabaseMetaData and see if the tables are there, and if not create them.

    If you need to deliver data, then, yes, just deliver the entire directory (make sure its not in use when you zip it, though), but make that the program is configured properly (as its location is liable to change, of course).

Similar Threads

  1. Default Access (package access) confusion
    By gauravrajbehl in forum New To Java
    Replies: 1
    Last Post: 11-18-2009, 10:48 AM
  2. Method access or field access
    By carderne in forum New To Java
    Replies: 2
    Last Post: 12-06-2008, 06:20 PM
  3. ms access jdbc query problem
    By Fleur in forum New To Java
    Replies: 2
    Last Post: 04-30-2008, 06:55 PM
  4. Replies: 0
    Last Post: 04-01-2008, 10:17 AM
  5. Replies: 0
    Last Post: 09-28-2007, 12:56 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
  •