This Java JDBC driver offers developers a seamless and efficient way to read and write Microsoft Access databases without the need for additional programs.
UCanAccess
UCanAccess is a Windows development utility that lets users connect Java applications to Microsoft Access databases. It is possible to manage internal transactions and maintain data integrity during complex operations.
Description
Using this tool you can establish a connection between any Java module and a remote or local database. There is support for the MDB and ACCDB file formats.
The driver is entirely written in Java, eliminating the need for external libraries and dependencies. Moreover, UCanAccess fully adheres to the Java Database Connectivity standard. Developers are able to interact with Access databases using familiar JDBC syntax and APIs.
Please note that the list of supported Microsoft Office versions includes only 2000, 2003, 2007 and 2010. Modern editions are not compatible with this driver.
Data types
Users can work with boolean, integer, long, single, double, numeric, currency, counter, text, OLE, memo, GUID and datetime values. There are tools for manually managing data transactions.
With the help of this program you are able to quickly access and manipulate remote databases. UCanAccess does not require external ODBC bridges to function correctly.
Features
- free to download and use;
- provides a custom JDBC driver for connecting Java apps to Microsoft Access databases;
- you can manipulate integers, counters, timestamps and other types of values;
- there are tools for managing internal transactions;
- compatible with all modern versions of Windows.