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
Enterprise-grade ITSM, for every business
Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
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 !