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.
License
GNU Library or Lesser General Public License version 2.0 (LGPLv2), Apache License V2.0Follow UCanAccess
Other Useful Business Software
Cahoot is the next-generation eCommerce order fulfillment network powered by our patented and easy-to-use shipping software. With 100+ eCommerce fulfillment centers throughout the United States, we offer nationwide 1-day and 2-day delivery to over 90% of the US population. Cahoot provides reliable and affordable US fulfillment services for ALL sales channels, including leading marketplaces such as Amazon, eBay, and Walmart and leading eCommerce platforms and shopping carts, including Shopify, BigCommerce, and Magento. Cahoot is the world's first peer-to-peer eCommerce fulfillment network that provides ultrafast order fulfillment at 30% lower cost than traditional 3PLS.
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 !