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

Project Activity

See All Activity >

License

GNU Library or Lesser General Public License version 2.0 (LGPLv2), Apache License V2.0

Follow UCanAccess

UCanAccess Web Site

Other Useful Business Software
The Voice API that just works | Twilio Icon
The Voice API that just works | Twilio

Build a scalable voice experience with the API that's connecting millions around the world.

With Twilio Voice, you can build unique phone call experiences with one API, to create, receive, control and monitor calls with just a few lines of code. Create an engaging voice experience that you can quickly scale and modify with a wide array of customization options and resources.
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
19
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5

User Reviews

  • The author made a great work. I use UCanAccess every time I need to program in Java
    3 users found this review helpful.
  • 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
    2 users found this review helpful.
  • 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!
    3 users found this review helpful.
  • Developers seem to be very motivated. Projects works, some things are not perfect yet, but it's much better than a few years ago.
    2 users found this review helpful.
  • Incredible project and very useful, Many thanks to the author !
    1 user found this review helpful.
Read more reviews >

Additional Project Details

Languages

English

Programming Language

Java

Database Environment

JDBC

Related Categories

Java Database Software, Java Front-Ends, Java Libraries

Registered

2012-11-18