Ucanaccess

<div style="text-align: center;"> <p> <a href="https://central.sonatype.com/artifact/io.github.spannm/ucanaccess"> <img src="https://img.shields.io/maven-central/v/io.github.spannm/ucanaccess?label=Maven%20Central" alt="Maven Central Version"> </a> <img src="https://img.shields.io/maven-central/last-update/io.github.spannm/ucanaccess?label=Last%20Update" alt="Maven Central Last Update"> <a href="https://github.com/spannm/ucanaccess/actions/workflows/ci_jdk11_ubuntu.yml"> <img src="https://img.shields.io/github/actions/workflow/status/spannm/ucanaccess/ci_jdk11_ubuntu.yml?label=Build%20(JDK%2011%20Linux)" alt="GitHub Actions Workflow Status"> </a> <a href="https://github.com/spannm/ucanaccess/actions/workflows/ci_jdk11_win.yml"> <img src="https://img.shields.io/github/actions/workflow/status/spannm/ucanaccess/ci_jdk11_win.yml?label=Build%20(JDK%2011%20Win)" alt="GitHub Actions Workflow Status"> </a> <a href="https://github.com/spannm/ucanaccess/stargazers"> <img src="https://img.shields.io/github/stars/spannm/ucanaccess?logoColor=%233a82c2" alt="GitHub Repo stars"> </a> </p> <h1>UCanAccess</h1> <h3>The modern bridge between Java and Microsoft Access</h3> </div>

UCanAccess is a high-performance, open-source Java JDBC driver that gives you seamless access to Microsoft Access databases (.mdb and .accdb) without needing any native Windows libraries (R-I-P OdbcJdbcBridge 🪦).

Whether you are building a modern Spring Boot application or using classic tools like LibreOffice or SQuirreL SQL, UCanAccess provides a reliable, pure-Java way to read and write your data.

<div align="center"> ──────────────────── </div>

✨ Key Features

• Pure Java Power: Zero native dependencies. Runs anywhere Java 11+ is supported.

• Drop-in Replacement: Fully compatible with previous UCanAccess versions.

• Modern Core: Built on top of the latest Jackcess 5.1.2 and HSQLDB 2.7.4 for maximum stability and security.

• Comprehensive SQL Support: Supports SELECT, INSERT, UPDATE, DELETE, and even complex DDL operations like ALTER TABLE.

• Access-like Logic: Includes built-in Access functions (like IIf, Nz, and financial functions like PMT or PV).

• Security Conscious: Regularly updated to be free of known CVEs.

<p style="height: 20px;">&nbsp;</p>

🛠 Tech Stack & Requirements

• Java Version: 11 or higher (LTS versions like Java 17 and 21 are fully supported and tested).

• Build Tool: Maven

• Main Dependencies:

  • Jackcess

  • HyperSQL Database (HSQLDB)

<p style="height: 20px;">&nbsp;</p>

📦 Installation

To use UCanAccess in your project, add the following dependency.

Maven (pom.xml)

<dependency>
    <groupId>io.github.spannm</groupId>
    <artifactId>ucanaccess</artifactId>
    <version>5.1.5</version>
</dependency>

Gradle (Groovy / build.gradle)

implementation 'io.github.spannm:ucanaccess:5.1.5'

Gradle (Kotlin DSL / build.gradle.kts)

implementation("io.github.spannm:ucanaccess:5.1.5")

<p style="height: 20px;">&nbsp;</p>

🚦 Quick Start

Connecting to your database is as simple as:

import java.sql.Connection;
import java.sql.DriverManager;

String url = "jdbc:ucanaccess://C:/path/to/your/database.accdb";
try (Connection conn = DriverManager.getConnection(url)) {
    // your code here
}

<p style="height: 20px;">&nbsp;</p>

❤️ Why this Fork?

The original project (developed by Marco Amadei and Gord Thompson) was the gold standard for Access connectivity but went quiet in 2020. As a long-time contributor and Java enthusiast, I decided to give UCanAccess a new home.

My goal is to keep this essential tool alive, maintain a high test coverage (JUnit 5), and ensure it meets modern Clean Code and SOLID standards.

<p style="height: 20px;">&nbsp;</p>

🤝 Contributions welcome!

Got a bug to fix or a feature to add?

1. Check out the Issues
2. Fork the Repo
3. Submit a Pull Request

Note: Please ensure your code follows the project's quality standards (Checkstyle, PMD are enforced in the build).

<div align="center"> ─────────────── </div>

⚖️ License

UCanAccess is licensed under the Apache License, Version 2.0.

<p style="height: 40px;">&nbsp;</p> <div align="center"> <table style="border-collapse: collapse;"> <tr> <td style="padding: 40px; border: 2px solid #3a82c2;"> <strong>Enjoying UCanAccess? Please leave a 🌟 to support the project!</strong><br> <small>Your stars help to keep the bridge between Java and Access alive and visible.</small> </td> </tr> </table> </div>