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
Next-Gen Encryption for Post-Quantum Security | CLEAR by Quantum Knight
CLEAR by Quantum Knight is a FIPS-140-3 validated encryption SDK engineered for enterprises requiring top-tier security. Offering robust post-quantum cryptography, CLEAR secures files, streaming media, databases, and networks with ease across over 30 modern platforms. Its compact design, smaller than a single smartphone image, ensures maximum efficiency and low energy consumption.
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 !
