MS Access JDBC Driver 1.2

MS Access JDBC Driver 1.2 has come as a useful package of drivers for pure Java Type 4 MS Access JDBC(1.2, 2.0, 3.0) which can be used for Microsoft Access version from 95, 97, 2000, XP, 2002, to 2003 and supports transaction, embedded mode, remote access mode, memory-only database, compressed database, and url database.

It supports all transactions level of READ UNCOMMITTED,READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. It supports concurrent database connections, and is thread safe. It supports embedded mode and remote access mode. It supports ANSI SQL 92 standard, more than 180 sql functions, XOPEN SQLState, RMI, Jini, JNDI, and serialization. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN,CROSS JOIN, self join, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery.

The drivers are completely written in Java and can be deployed on any platform with Java VM, which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. It supports Personal Java, JDK1.0.X, JDK1.1.X, JDK1.2.X, JDK1.3.X, JDK1.4.X and JDK1.5.X. It supports JDBC1.2, JDBC2.0, and JDBC3.0. It supports all of JVMs supported unicode, locales and encodings. Cp895(Czech MS - DOS 895), Cp620(Polish MS - DOS 620) and Mazovia are extra supported although JVM doesnt support those.

For remote access mode, it provides a GUI database server manager with remote control capability, which can run as Windows service, Unix/Linux daemon, or standalone application. It supports seamlessly files and directories in ZIP, BZ2, and TAR files((.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.