DownloadUCanAccess 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
GNU Library or Lesser General Public License version 2.0 (LGPLv2), Apache License V2.0Follow UCanAccess
You Might Also Like
RAD PDF natively supports the most commonly used PDF features. Beyond a PDF reader, RAD PDF equips web applications with a browser-based PDF editor & PDF annotator. Features not even available in Adobe Acrobat Reader can be used to provide advanced PDF functionality. By enabling PDF form filling & PDF form saving directly in the web browser, RAD PDF users can utilize PDF features without worrying about having the right platform or software installed! Allow your app to design new PDF forms, protect content, sign PDFs, & more using an intuitive graphical user interface (GUI).
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of UCanAccess!