Jackcess is a pure Java library for reading from and writing to MS Access databases. It is part of the OpenHMS project from Health Market Science, Inc.

There is no GUI. It is not an application. Jackcess is a library, intended for other developers to use to build Java applications.

Here are some key features of "Jackcess":

· Reads and writes Microsoft Access 2000,2002/2003,2007 databases
· Fully supports most Access data types
· Supports table creation, row create/update/delete
· Pure Java, no native library dependencies
· Provides read-only table relationship and SQL query information
· Cursors enable indexed lookup and advanced table traversal

What's New in This Release: [ read full changelog ]

· Add support for reading/writing complex column data (version history, attachments, multi-value columns).
· Fix problem with creating tables with indexes where ms access could not open the created table
· Fix problem with reading row from table with deleted/added columns
· Reuse previously written memo/ole values when updating other values in a row in order to reduce unnecessary data duplication
· Allow ImportFilter and ExportFilter to return null from filterRow() to indicate that a row should be skipped
· Add option to import file without headers to existing table
· Add ImportUtil.Builder and ExportUtil.Builder to simplify import/export operations