Java Direct Access MDB database file for MS Access

JDBC accesses the MDB database file for access and uses a development package called Ucanaccess to implement this functionality.

"Supported Access formats:2000,2002/2003,2007,2010/2013 Databases (1997 read-only)."

Official website in http://ucanaccess.sourceforge.net/site.html

Now by the wall.

Use ucanaccess JDBC Driver:
Class.forName ("Net.ucanaccess.jdbc.UcanaccessDriver");
Connection conn=drivermanager.getconnection ("Jdbc:ucanaccess://<mdb or ACCDB file path>", user, password);
For example:
Connection conn=drivermanager.getconnection ("Jdbc:ucanaccess://c:/pippo.mdb");

MAVEN Coordination:

<dependency>
<groupId>net.sf.ucanaccess</groupId>
<artifactId>ucanaccess</artifactId>
<version>3.0.2</version>
</dependency>

Reference http://stackoverflow.com/questions/16626301/jdbc-driver-ms-access-connection

Java Direct Access MDB database file for MS Access