UCanAccess 2.0.9

A very useful and reliable, Java based JDBC driver for MS Access that helps you in the development process
UCanAccess is a handy, Java based JDBC driver that enables developers and JDBC client applications to read or write Microsoft Access databases.

Moreover, UCanAccess is developed using the Java programming language and can be run on Mac OS X, Windows and Linux.

Main features:

  • Supports the 2000, 2003, 2007, 2010 Access formats
  • Execute queries defined as well as saved in Access
  • Provides access for multiple users.
  • SELECT, INSERT, UPDATE, DELETE statements. Transactions and savepoints.
  • 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. Since 1.0.1 version, UCanAccess can execute crosstab queries (Transfom...Pivot...)
  • LIKE operator accepts both standard '_' and access specific '?' as wildcard character, both standard '%' and access specific '*' as jolly, # for single digit(access), [xxx][!xxx]for characters intervals.
  • Both & and || string concat.
  • Square brackets for field names, table names and view names (Access Queries) including spaces (e.g., select [my column] from [my table] ).
  • Access date format (e.g., #11/22/2003 10:42:58 PM#).
  • Both double quote " and single quote ' as SQL string delimeters.
  • Basic, readonly support to complex types (i.e., array of Version, Attachment, SingleValue). Tables with one or more colums of those types are readable but readonly in the current development stage. Using ResultSet.getObject you can get array of net.ucanaccess.complex.Version, net.ucanaccess.complex.Attachment and so on.
  • Command Line Console. You can run SQL commands and display their results. CSV export command.

last updated on:
September 13th, 2014, 19:18 GMT
file size:
2.5 MB
developed by:
Marco Amadei
license type:
operating system(s):
Mac OS X
binary format:
Home \ Developer Tools


In a hurry? Add it to your Download Basket!

user rating 2



2 Screenshots
What's New in This Release:
  • A major bug has been fixed for several damaged mdb: the table data was incorrectly and partially loaded in previous versions. A table in an access database has a row count in its metadata, and this issue was due to a misalignment between row count in the metadata and the real number of table rows. So, it has been fixed in UCanAccess 2.0.9 by avoiding to rely on this metadata information while loading data. Also, UCanAccess 2.0.9 will raise a warning in these cases.
  • Strongly improved the UCanAccess behaviour in the case of multiple processes concurrency.
  • Added connection parameter columnOrder to allow to use, in your SQL, the "display" order ("data" order is still the default) e.g., jdbc:ucanaccess://c:/db/cico.mdb;COLUMNORDER=DISPLAY. Once a column order has been setted on the first connection to a given database, the column order setting will be the same for all the following connections to that database, in the whole VM life.
  • Allowed special characters and blank spaces in DDL. Column and table names, in this specific case, are not more escaped in the persisted table definition on the access file, but just in the mirror hsqldb database. e.g. CREATE TABLE [result ccc]( [aa a()] autoincrement PRIMARY KEY, [---bghhaaf b aa] text(222) default 'vvv') DROP TABLE [result ccc] Notice that you have to use square brackets or backtick around the column/table name.
read full changelog

Add your review!