UCanAccess Icon

UCanAccess

A pure java JDBC Driver for MS Access

5.0 Stars (13)
707 Downloads (This Week)
Last Update:
Download UCanAccess-2.0.9.5-bin.zip
Browse All Files
Windows Mac Linux

Screenshots

Description

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.

UCanAccess Web Site

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.

KEEP ME UPDATED

User Ratings

★★★★★
★★★★
★★★
★★
13
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
Write a Review

User Reviews

  • hartwigthomas
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Becomes even more important, as the old JDBC-ODBC bridge from SUN will not work under JAVA 8 any more.

    Posted 10/30/2014
  • nigelvthomas
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Great asset for programmatic access to Microsoft Access Databases.

    Posted 10/02/2014
  • robertino129
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Easy, supported, and features that do not exist can be requested and implemented which leads back to support.

    Posted 06/24/2014
  • gordonthompson
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    This was a wonderful discovery even before the demise of the JDBC-ODBC Bridge in Java 8. It is even more valuable now. THANKS!!

    Posted 04/18/2014
  • kenchis
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Since ODBC-JDBC bridge is no longer supported by JDK8 you just make my day! Between now MDB can be accessed in Win and Linux!? Thank you so much!

    Posted 03/24/2014
Read more reviews

Additional Project Details

Languages

English

Programming Language

Java

Registered

2012-11-18
Screenshots can attract more users to your project.
Features can attract more users to your project.