{"repo":"spannm/ucanaccess","free":true,"listed":false,"github":"https://github.com/spannm/ucanaccess","clone":"git clone https://github.com/spannm/ucanaccess.git","description":"Open-source pure Java JDBC driver for Microsoft Access databases (*.accdb, *.mdb). Enables client programs (e.g. OpenOffice, LibreOffice, Matlab, SQuirreL) to read and write Access databases.","language":"Java","stars":98,"topics":["driver","jdbc","microsoft","msaccess","purejava","sql","database","hsqldb","jackcess","junit5"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"UCanAccess The modern bridge between Java and Microsoft Access UCanAccess is a open-source pure-Java JDBC driver that gives you seamless access to Microsoft Access databases ( .mdb , .accdb ) without needing any native Windows libraries - R.I.P. OdbcJdbcBridge 🪦. New to UCanAccess? Check out the introduction guide on Foojay.io: UCanAccess – Java MS Access JDBC Guide ✨ 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.5 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.   🛠 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)   📦 Installation To use UCanAccess in your project, add the following dependency. Maven ( pom.xml ) Gradle (Groovy / build.gradle ) Gradle (Kotlin DSL / build.gradle.kts )   🚦 Quick Start Connecting to your database is as simple as:   ❤️ Why this Fork? The original project (developed by Marco Amadei and Gord Thompson) was the g","default_branch":null,"files":null,"tree":[],"storefront":"/r/spannm","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/spannm/ucanaccess/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}