A pure Java library for reading from and writing to MS Access databases.

Features

  • Reads and writes Microsoft Access 2000,2002/2003,2007,2010/2013,2016,2019 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
  • Supports expression evaluation in default values, calculated fields, and field/record validators

Project Activity

See All Activity >

Categories

Database, Libraries

License

Apache License V2.0, GNU Library or Lesser General Public License version 2.0 (LGPLv2)

Follow Jackcess

Jackcess Web Site

nel_h2
Simply solve complex auth. Easy for devs to set up. Easy for non-devs to use. Icon
Simply solve complex auth. Easy for devs to set up. Easy for non-devs to use.

Transform user access with Frontegg CIAM: login box, SSO, MFA, multi-tenancy, and 99.99% uptime.

Custom auth drains 25% of dev time and risks 62% more breaches, stalling enterprise deals. Frontegg platform delivers a simple login box, seamless authentication (SSO, MFA, passwordless), robust multi-tenancy, and a customizable Admin Portal. Integrate fast with the React SDK, meet compliance needs, and focus on innovation.
Start for Free
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
10
3
0
0
0
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

  • Best Project Ever!
  • Outstanding! Already great and getting better.
  • Works great and support is incredible!
  • I've been using Jackcess for a very long time now in my projects and I love it. Great tool, great support, fast and reliable.
  • A great library. Thank you!
Read more reviews >

Additional Project Details

Languages

English

Intended Audience

Developers

Programming Language

Java

Database Environment

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

Related Categories

Java Database Software, Java Libraries

Registered

2005-03-25