Search code examples
javams-accessucanaccess

Connect to an Access database from Java 8 without using UCanAccess


I am trying to connect to a local .mdb file using Java 8. So far I have used UCanAccess's libraries but not all features are supported.

In Java 8 "JDBC/ODBC was scrapped"... So my question is:

What is the new method to connect to .mdb files (without UCanAccess)?


Solution

  • If you really don't want to use UCanAccess then you'll probably have to buy a third-party library

    • to replace the JDBC-ODBC Bridge that was removed from Java 8, or

    • to provide direct JDBC connectivity to the Access database.

    However, as Marco indicates in his comment to the question, there could very well be UCanAccess (or HSQLDB) workarounds for your "feature not supported" issues if you care to give us a hint as to what they are.