Java Database Connectivity with MS Access --- Part 1

It is very easy to make a Java program talk to database on Microsoft Access. Here, we connect the Java program to the database by JDBC-ODBC Bridge Driver.

We do not need any JAR files to be included as JDBC is a part of Java API and the connection is through JDBC-ODBC Bridge Driver.

Suppose we have a database in MS Access as given below:

Save this database in "accdb" or "mdb" format. As we are connecting through JDBC-ODBC Birdge driver, we have to create Data Source Name (DSN) for the respective database. The steps for creating a DSN is as follows:

1. Open "Control Panel" ----  "Administrative Tools" ---- "Data Sources (ODBC)". You get a window like this:
   
   
2. Now click on the "Add" Button which would then look like:
   
   
3. Select "Microsoft Access Driver (*.mdb, *.accdb)" option and click on "Finish" button which invokes one more wizard where you are supposed to give the "Data source name" and select the database file (.mdb or .accdb). After selecting the database where you stored the table, click OK and the DSN named "StudentInfo" is created.