Reply to thread

Message: [QUOTE="Tushar, post: 600103"] here is my code ........ even on using the update statemnt it is not updating the DB? Any suggestions? import java.sql.*; class Example { public static void main(String args[]) { try { String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + "c:/db2.mdb"; System.out.println(url); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection myConnection = DriverManager.getConnection(url,null, null); //SQL String q= " UPDATE Addresses SET ID='3',Name='MAnik',LastName='Desai',Spouse='Sabrina'"; Statement myStatement =myConnection.createStatement(); int rs = myStatement.executeUpdate(q); //Closing Statement myStatement.close(); //Closing Connection myConnection.close(); } catch(java.lang.Exception ex) { ex.printStackTrace(); } } } [/QUOTE]