Search code examples
javadatabasems-access

Get data from .accdb file

I've been searching for the solution to open a .accdb database and read/write date from and into this file. The file is saved locally and not on a server and the solution should work without additional libraries.

Can someone help me?

Thank you for your advice

Solution

  • My recommendation would be to use UCanAccess.

    The other common approach on Windows is was to use the JDBC-ODBC Bridge in conjunction with the Microsoft Access ODBC driver, but

    1. that method has some limitations, particularly with respect to full Unicode support, and

    2. the JDBC-ODBC Bridge has been removed from Java SE 8 and is not supported (ref: here).

    For more information on UCanAccess see

    Manipulating an Access database from Java without ODBC