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.

Features

  • Reads and writes Microsoft Access 2000,2002/2003,2007,2010/2013,2016 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
  • Full support for reading/writing table relationships, with foreign key enforcement
  • 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
  • Provides read-only embedded SQL query information

Project Activity

See All Activity >

Categories

Database, Libraries

Follow Jackcess

Jackcess Web Site

Other Useful Business Software

Pyramid - The Complete Self-Service Analytics Platform Pyramid - The Complete Self-Service Analytics Platform Icon
Pyramid - The Complete Self-Service Analytics Platform Icon

Easily combine data from multiple sources to build dashboards and reports with our scalable solution built for mid-size to enterprise companies.

Pyramid combines analytic tools often found in separate applications. It features a graphically based ETL to model data and incorporate machine learning algorithms, intuitive data discovery tools that produce simple and advanced visualizations, a presentation builder for creating analytic applications and presentations, and an enterprise-grade report builder—all in a single, integrated platform that can be accessed from any browser or device.

Rate This Project

Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
11
3
0
0
1
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 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 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

User Reviews

  • this tool is must have.

Read more reviews >

Additional Project Details

Languages

English

Intended Audience

Developers

Programming Language

Java

Database Environment

Project is a tool for a proprietary database file format, Microsoft Access

Registered

2005-03-25