Jackcess Icon

Jackcess

4.4 Stars (10)
213 Downloads (This Week)
Last Update:
Download jackcess-2.0.5.jar
Browse All Files
Windows Mac Linux

Description

A pure Java library for reading from and writing to MS Access databases. This project is part of the OpenHMS (http://openhms.sourceforge.net/) project from Health Market Science.

Jackcess Web Site

Features

  • Reads and writes Microsoft Access 2000,2002/2003,2007,2010 databases (1997 read-only)
  • Fully supports most Access data types
  • Supports table creation, index creation, row create/update/delete
  • Pure Java, no native library dependencies
  • Provides read-only table relationship and embedded SQL query information
  • Cursors enable indexed lookup and advanced table traversal
  • Reads database password in all supported versions
  • Pluggable codec provider allows handling of encoded file types (see Jackcess Encrypt project)
  • Support for the complex data types added in Access 2007/2010

Update Notifications





User Ratings

★★★★★
★★★★
★★★
★★
7
2
0
0
1
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 3 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 3 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
Write a Review

User Reviews

  • branchoflight
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Used it to write a front end to manage a non-profit's back end. Worked great!

    Posted 07/02/2014
  • amgohan
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    take a look at h_t_t_p_s://github.com/amgohan/jackcess-orm/ a project that i initiated jackcess-orm a mini ORM for mapping MSAccess tables to Java POJOs using JPA annotations and jackess library

    Posted 03/28/2014
  • serverfrog
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    good job. But better would it be if there where methods to get typed values (getInt and so on) on tables and informations when a key is not in a table (make a find with Type Long for a field which is Integer, that result that he dont find a row).

    Posted 01/30/2014
  • jameshanson
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    good job jackcess

    Posted 10/27/2012
  • leolopez
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    thank you jackcess

    Posted 09/12/2012
Read more reviews

Additional Project Details

Languages

English

Intended Audience

Developers

Programming Language

Java

Registered

2005-03-25

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.