UCanAccess: The Modern Pure-Java Bridge to Microsoft Access

UCanAccess is an open-source, pure-Java JDBC driver that enables reading and writing Microsoft Access (.mdb and .accdb) databases without native Windows drivers or ODBC bridges. Originally created by Marco Amadei and Gord Thompson, the project was revived in 2022 after going dormant. It supports Java 11+, runs cross-platform (Linux, macOS, Windows), and integrates with any JDBC-compatible tool including DBeaver, LibreOffice Base, and SQuirreL SQL. The driver supports full DML, some DDL, and emulates Access-specific SQL functions like IIf(), Nz(), and Format(). It is available on Maven Central as both a standard dependency and an Uber JAR for non-Maven environments.