How to connect to MS Access?

[thatos]

I have the following code but its unable to connect to the database.

import java.sql.*;
import javax.sql.*;

public class firstD {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String caller;
		String product;
		
		String query = "SELECT * FROM tblEmployee";
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con = DriverManager.getConnection("C:/Users/sthato/workspace/Database1/Call Tracking2");
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while(rs.next()){
				//caller = rs.getString("Caller");
				//product = rs.getString("Product");
				System.out.println(rs.getString("Title"));
			}
			con.close();
		}
		catch(ClassNotFoundException e){
			e.printStackTrace();
		}
		catch(SQLException e){
			e.printStackTrace();
		}

	}

}

Can someone please help, my database name is Call Tracking2.accdb .
I have checked if the driver for accdb is enabled and it is .
I have also replaced my file path with "jdbc:odbc: Call Tracking2" but I get the error.

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at firstD.main(firstD.java:17)

please help

[thatos]

I have added the database to data source, and the code works.

[Dheeraj Joshi]

Hi Following statement is wrong.

Connection con = DriverManager.getConnection("C:/Users/sthato/workspace/Database1/Call Tracking2");

The getConnection method syntax is

jdbc:sqlserver://server;user="login_name";password="MyPwd"

getConnections is a overloaded function. Please see this link for more info.

Regards
Dheeraj Joshi