Dear viewers,
when i compile with jcreator (SimpleDeleteSelect.java)it says process completed,and when i run there are error message ...my database(ms access) cannot perform deletion but all my friends with laptop don't face any problem and desktop in my college also face the same problem with mine at home......what is the problem ???
My connection path between jcreator with ms access is
Control Panel-->Administrative Tool-->Data Sources--> MS Access Database--> add-->ms access driver(.mdb)-->data source name=TARCollegeDB-->create-->then i the path where i save my file(Ms access)-->then press OK three times
(Please verify my path)

================================================== ======
//error message
Driver loaded...

Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.j ava:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOd bcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDrive r.java:174)
at java.sql.DriverManager.getConnection(DriverManager .java:582)
at java.sql.DriverManager.getConnection(DriverManager .java:207)
at SimpleInsertSelect.main(SimpleInsertSelect.java:12 )

Process completed
================================================== =====
//the coding of SimpleDeleteSelect.java
import java.sql.*;

public class SimpleDeleteSelect {

public static void main(String[] args) throws SQLException, ClassNotFoundException{

// load the JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Driver loaded...\n");

// establish a connection
Connection conTARCollegeDB = DriverManager.getConnection("jdbc:odbc:TARCollegeD S");
System.out.println("College database connnected...\n");

// create a statement
Statement stmtDelete = conTARCollegeDB.createStatement();

// execute a statement
stmtDelete.executeUpdate("DELETE FROM Course WHERE CourseID = 'CCS';");

// create a statement
Statement stmtSelect = conTARCollegeDB.createStatement();

// execute a statement
ResultSet rsStudent = stmtSelect.executeQuery("SELECT * FROM Course;");

// loop through the ResultSet and print out student details
while(rsStudent.next()){
System.out.println("Course ID: " + rsStudent.getString(1)+ "\t\tCourse Description: " + rsStudent.getString(2));
}
} // end main
} // end class