Jackcess

If you are looking for an advanced software utility that can help you read and write MS Access databases, Jackcess could prove helpful since it claims to do precisely that.

Before anything else, it is important to mention that Microsoft Access 2000, 2002/2003, 2007, and 2010/2013 databases can be successfully handled by Jackcess, with Access 97 interaction being limited to read-only.

Regarding the users targeted by such a tool, it is important to point out that Jackcess packs no GUI and that it addresses developers interested in integrating MS Access support into the Java programs they build, removing the dependency and banking on the idea of portability.

The Java library comes with support for a multitude of tasks, such as creating tables, creating indexes, managing rows, and much more, aside from the fact that reading or writing table relationships is also possible, with foreign key enforcement being on the feature list as well.

Complex data types integrated into Access 2007/2010 should raise no difficulty either, and the same can be said about enabling indexed lookup and advanced table traversal.

Apart from that, it should be noted that Jackass can work with password-protected databases without meeting any inconveniences.

Considering that no ODBC configuration is required, Jackcess’ responsiveness is implied, even though its strength remains its functionality, and not its speed.