Last modified on 20 January 2015, at 14:14

Java Programming/Database Programming

Networking Java Programming
Database Programming
Reflection
Navigate Advanced topic: v  d  e )

Connecting to MS Access databasesEdit

The following is used to open an ODBC connection to an Access database. Note that the username (and password, if applicable) are given in the dsn rather than the getConnection call. This is a MS Windows-only example, due to the requirement for the Microsoft Access Driver.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String path = "C:/example.mdb";
String dsn = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + path + ";UID=admin";
accessConn = DriverManager.getConnection(dsn, "", "");