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
License
Apache License V2.0, GNU Library or Lesser General Public License version 2.0 (LGPLv2)Follow Jackcess
Other Useful Business Software
AI-generated apps that pass security review
Retool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
Rate This Project
Login To Rate This Project
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!