Download
UCanAccess is a pure Java JDBC Driver implementation which allows Java developers and JDBC client programs to read/write Microsoft Access database (.mdb and .accdb) files. No ODBC needed.
Features
- Supported Access formats: 2000, 2003, 2007, 2010.
- SELECT, INSERT, UPDATE, DELETE statements. Transactions and savepoints.
- Access data types: YESNO, BYTE, INTEGER, LONG, SINGLE, DOUBLE, NUMERIC, CURRENCY, COUNTER, TEXT, OLE, MEMO, GUID, DATETIME.
- Concurrent access from multiple users (i.e., multiple application server threads).
- Connection pooling.
- ANSI 92 SQL, core SQL-2008.
- MS Access SQL.
- Main Access functions implementation.
- You can execute select queries defined and saved in Access.
- Criteria in LIKE clause.
- Access date format (e.g., #11/22/2003 10:42:58 PM#).
- Both double quote " and single quote ' as SQL string delimeters.
- Command Line Console. You can run SQL commands and display their results. CSV export command.
Project Samples
License
Apache License V2.0, GNU Library or Lesser General Public License version 2.0 (LGPLv2)Follow UCanAccess
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
-
The author made a great work. I use UCanAccess every time I need to program in Java
-
I have benefited from this project a lot .. because Java is no longer supporting access odbc .. Thank you authors but there are some features do not exist .... Thank you
-
Really useful project, if you need to use MS Access databases; some important feature is not present yet, but people involved in the project are always quick and helpful on the forum. Thanks to these people!
-
Developers seem to be very motivated. Projects works, some things are not perfect yet, but it's much better than a few years ago.
-
Incredible project and very useful, Many thanks to the author !
