StelsMDB is a MDB JDBC type 4 driver that allows you to perform SQL queries and other JDBC operations on Microsoft Access database (versions 2000-2010) files. The driver is completely platform-independent and does not require installing additional client or server software to provide access to MDB files. It can be effectively used to create, process, and export Microsoft Access databases in your Java applications. It supports most keywords of ANSI SQL'92, supports inner and outer table joins, supports CREATE, INSERT, UPDATE, and DELETE statements, supports transactions, and supports aggregate, numeric, string, conversion, and user-defined SQL functions.
|Tags||Database Database Engines/Servers API Software Development Libraries Java Libraries|
|Operating Systems||OS Independent|
Release Notes: Performance has been improved for multiple threads The "watchFileModifications" property has been added. It allows refreshing the driver cache if a MDB file was modified by some external process.
Release Notes: The CURRENCY data type is now stored as BigDecimal (java.sql.types.Numeric). HYPERLINK is now supported as a separate data type.
Release Notes: Performance for update and delete queries was improved. Linked tables are now supported. New "preSQL" and "singletonConnection" driver properties were added.
Release Notes: A new mode of the driver has been added. MS Access 2010 files are now supported.
Release Notes: The H2 database is now used as an SQL engine.