Latest feature:

• v3.1.011 fixed a bug on ResultSet.last() since v3.0.046.
• v3.1.011 optimizes speed for full table search on large file without index.
• v3.1.005 provides ODBCCaseInsensitiveBehavior to work like MS Access ODBC driver to be case insensitve for string comparison.
• v3.1.004 supports WITH ROLLUP, WITH CUBE, and GROUPING(expression).
• v3.1.004 supports bitwise logical operator(&, |, ~, ^, <<, >>), BITAND(x, y), and BIT_COUNT(x).
• v3.1.002 begins to maintain deleted index expression since MS Access' query utilizes those information.

2008-07-23 Access v3.1 JDBC1.2 Package(2194KB) JDBC2.0 Package(2183KB) JDBC3.0 Package(2227KB)

• v3.0.048 fixed an infrequent bug which detects a normal index expression as deleted index expression when that deleted index uses the same internal index identity.
• v3.0.046 fixed a bug since v3.0.040.
• v3.0.040 optimizes speed.
• v3.0.036 supports GROUP_CONCAT function.
• v3.0.035 supports to assign more than one extension for otherExtension connection property.
• v3.0.034 supports lower(upper) function in LIKE expression.
• v3.0.031 fixed a bug on utilizing part expression of component index to quicken IN query.
• v3.0.026 quickened self insert.
• v3.0.025 fixed a bug on utilizing part expression of component index to quicken query.
• v3.0.017 supports invisible VIEW type in MS Access.
• v3.0.001 supports INTO variable[,...] for SELECT sql.
• v3.0.001 supports SET variable = expression [,...].
• v3.0.001 supports DECLARE Local Variables.

2007-10-29 Access v3.0 JDBC1.2 Package(2236KB) JDBC2.0 Package(2225KB) JDBC3.0 Package(2270KB)

• v2.1.084 replaced "? Expression" with "SELECT select_list".
• v2.1.083 provides CURRVAL(cTableName, cColumnName) to fetch the last generated IDENTITY(auto_increment) value for a particuar table.
• v2.1.080 provides SHA1 function besides MD5 and Crypt3.
• v2.1.076 will recycle space for REINDEX operation.
• v2.1.076 fixed a string index bug in JET3 database engine for a few sort orders since v2.1.006.
• v2.1.073 solved a strange issue which some memo messages show abnormally with MS Access 2003 and 2007 on MS Windows 2003 and Vista, but normally with MS Access 200 and 2003 on MS Windows 2000 and XP.
• v2.1.070 can understand very complicated VIEW(QUERY of MS ACCESS) with more than 15 JOIN table relations.
• v2.1.068 changed the visibility of columns in JOIN table with parentheses from invisible to visible.
• v2.1.068 supports JOIN and subquery in PIVOT and UNPIVOT.
• v2.1.068 supports a variety of sort orders for JET4 database(General, German Phone Book, France, Icelandic, Dutch, Traditional Spanish, Spanish, Swedish/ Finnish, Croatian, Czech, Hungarian, Polish, Romanian, Slovak, Slovenian, Estonian, Latvian, Lithuanian, Macedonian, Ukrainian, Chinese Stroke Count (Taiwan), Georgian Modern, Hungarian Technical, Japanese Unicode, Korean Unicode, Chinese Pronunciation, Chinese Stroke Count, Turkish, Vietnamese, Chinese Bopomofo (Taiwan), Japanese, Korean, and Thai).
• v2.1.057 supports seamlessly https url database in jdbc url and sql.
• v2.1.051 fixed a bug for utilizing index on LIKE '%'.
• v2.1.048 fixed a seldom bug for CREATE TABLE into JET4 version database.
• v2.1.037 fixed a bug for insert very long data into JET3 version database.
• v2.1.010 supports AUTO_INCREMENT in CREATE TABLE sql
• v2.1.001 supports SAMBA table, which needn't to map or mount driver.

2007-01-11 Access v2.1 JDBC1.2 Package(905KB) JDBC2.0 Package(895KB) JDBC3.0 Package(935KB)

• v2.0.047 optimizes memory occupation for UNION ALL.
• v2.0.044 added CP850, CP852, CP866, CROATIAN, HEBREW, and SWEDISH sort for COLLATE function.
• v2.0.043 fixed a slow speed issue since v2.0.035 which was resulted by cascading check.
• v2.0.043 utilizes constant DEFAULT value for create table sql and insert sql.
• v2.0.041 fixed a bug for insert very long data into JET3 version database.
• v2.0.041 supports fully ALTER TABLE sql.
• v2.0.041 supports DROP INDEX sql.
• v2.0.036 fixed a bug on DELETE operation for a special seldom occasion.
• v2.0.035 supports cascading updates and cascading deletes of MS Access.
• v2.0.023 supports to use more than one column as primary key in create table sql.
• v2.0.022 optimizes speed of ResultSet.absolute function.
• v2.0.021 fixed a bug in using ResultSet.absolute function.
• v2.0.018 fixed an incompatible issue for MS Access 97's CLOB value with more than 2048 length. HXTT Access can read those older inserted CLOB values, but MS Access will show an error data prompt, then can show correctly those "error" CLOB data.
• v2.0.014 optimizes speed for UNION.
• v2.0.012 provides maxIdleTime connection property. maxIdleTime indicates the max idle time in minute for remote connection. That option is mainly used to avoid closing automatically idle remote connection for connection pool. Embedded idle connectoin won't be closed automatically except for garbage collection. You can use 1~1440 minutes. Default: 15.
• v2.0.011 supports REINDEX sql.
• v2.0.004 can detect the latest inserted rows by other MS Access applications with delayedClose=0.

2006-08-07 Access v2.0 JDBC1.2 Package(980KB) JDBC2.0 Package(966KB) JDBC3.0 Package(1005KB)

• v1.2.025 fixed a bug in string index optimization since v1.2.021 released on June 21, 2006.
• v1.2.022 optimizes VIEW query.
• v1.2.021 supports TRANSFORM VIEW.
• v1.2.020 supports PIVOT and UNPIVOT.
• v1.2.015 provides CDATE(expression,pattern) for date conversion.
• v1.2.008 fixed a bug in index result cache.
• v1.2.004 supports index on special (national) characters, like ä.
• v1.2.003 supports RENAME TABLE sql.

2006-05-17 Access v1.2 JDBC1.2 Package(852KB) JDBC2.0 Package(843KB) JDBC3.0 Package(883KB)

• v1.1.036 fixed a bug in inserting row into mdb file with 127MB size.
• v1.1.035 fixed a bug in parsing value for numeric column with scale>10.
• v1.1.032 fixed a bug in DatabaseMetaData.getTables() since v1.1.028.
• v1.1.028 supports most simple stored procedures (select, insert, update, and delete) for JDBC3.0 package. You should test your stored procedure first to see whether it's supported by HXTT Access
• v1.1.024 supports seamlessly url(http, ftp) database in jdbc url and sql.
• v1.1.024 supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
• v1.1.024 supports seamlessly files and directories in TAR and BZ2 file formats(.TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
• v1.1.017 provides otherExtension connection property to support other extension beside 'MDB' and 'MDE'.
• v1.1.015 provides TABLELOCKED(cTableName) function.
• v1.1.001 provides lock table and unlock table sql.

2006-03-07 Access v1.1 JDBC1.2 Package(807KB) JDBC2.0 Package(822KB) JDBC3.0 Package(853KB)

• v1.0.142 optimizes IN, NOT IN, ALL, and ANY on subquery.
• v1.0.133 provides SSL connection and customer connection for client/server mode.
• v1.0.130 supports seamlessly files and directories in ZIP and GZIP file formats(.ZIP, .JAR, .GZ) in jdbc url and sql.
• v1.0.129 changed CREATE SCHEMA sql to CREATE CATALOG
• v1.0.129 changed [schemas.]tableName@[catalog] format to [catalog.]tableName
• v1.0.128 supports MDE suffix
• v1.0.115 supports column numbers in ORDER BY clause
• v1.0.114 supports Multiple-row VALUES tables.
• v1.0.104 optimizes speed.
• v1.0.100 supports MySQL Migration Toolkit v1.0.21
• v1.0.98 supports aggregate function first(x), last(expression).
• v1.0.96 supports function ATN(x), CBOOL(expression), CBYTE(expression), CDBL(expression), CINT(expression), CLNG(expression), CSNG(expression), CSTR(expression), and CDATE(expression).
• v1.0.62 supports DROP TABLE
• v1.0.28 supports all of four transaction levels.
• supports CREATE DATABASE

2005-09-12 Access v1.0 JDBC1.2 Package(731KB) JDBC2.0 Package(752KB) JDBC3.0 Package(777KB)

• supports MySQL Migration Toolkit v1.0.20
• supports CREATE TABLE and CREATE INDEX
• supports MS Windows service and Linux Daemon for remote connection and remote control
• supports VIEW(QUERY of MS ACCESS) with/without parameter.
• supports DISTINCTROW.
• supports Linked Table to other Access databases
• provides ILIKE syntax support,ignore upper and case like

2005-06-01 Access Beta1.0 JDBC1.2 Package(698KB) JDBC2.0 Package(712KB) JDBC3.0 Package(732KB)

• Development Documentation is available.
• provides the quicker TCPServer to replace the slow RMIServer.
• provides Database GUI Manager.
• supports JDBC3.0, JDBC2.0 and JDBC1.2.
• provides Table Encryption and ColumnLevel Encryption.
• provides _LockFlag_ virtual column as row lock flag for Borland's dataset.
• provides encrypt/decrypt function for Row-Column (Cell) Level Encryption.
• provides transaction sql.