Download UCanAccess – JDBC Driver for Microsoft Access Databases

UCanAccess is a free, open-source JDBC driver that enables Java applications to read and write Microsoft Access database files (.mdb and .accdb) without requiring Microsoft Access or any Microsoft Office component to be installed on the system. It allows Java programs to interact with Access databases using standard JDBC and SQL syntax.

Built on top of the Jackcess library and the HSQLDB in-memory database engine, UCanAccess translates SQL queries into Access-compatible operations transparently. Developers can use it with any Java IDE or framework that supports JDBC — including NetBeans, Eclipse, IntelliJ IDEA, Spring, and Hibernate — to access legacy Access databases from Java applications running on Windows, macOS, or Linux.

UCanAccess supports DDL operations (CREATE TABLE, ALTER TABLE), DML (SELECT, INSERT, UPDATE, DELETE), indexes, relationships, complex data types, and many Access-specific functions. It is the go-to solution for Java developers who need to integrate with Microsoft Access databases in cross-platform environments.

Key Features

• No Microsoft Access required – Reads and writes .mdb and .accdb files purely in Java without any Office installation.
• Standard JDBC interface – Use familiar JDBC API, SQL queries, PreparedStatements, and ResultSets for all database operations.
• DDL and DML support – Supports CREATE, ALTER, DROP, SELECT, INSERT, UPDATE, DELETE, and more SQL operations.
• Cross-platform – Works on Windows, macOS, and Linux — access Access databases from any Java environment.
• Relationship and index support – Respects table relationships, primary keys, and indexes defined in the Access file.
• Access built-in functions – Supports many Access-specific SQL functions for compatibility with existing queries.
• Maven and Gradle compatible – Available as a Maven dependency for easy integration into build pipelines.

How to Install

1. Download the UCanAccess JAR (and its dependencies: Jackcess, HSQLDB, commons-lang, commons-logging) from the link below.
2. Add all JAR files to your Java project’s classpath or declare the Maven dependency: net.sf.ucanaccess:ucanaccess.
3. Register the JDBC driver in your code: Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
4. Connect to your Access file: Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:/path/to/database.accdb");
5. Execute SQL queries using standard JDBC PreparedStatement or Statement objects as with any other database.