Hi, Im trying to connect to MsAccess file using Eclipse, but im getting the error Code: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'. I have added the ojdbc14.jar to Bulid Path for the project & the access file is in the Bin Folder. & this is the code Code: try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=testdb2.mdb","",""); Statement stmt = con.createStatement(); String s = "insert into student values(521,'test1');"; stmt.executeUpdate(s); con.commit(); stmt.close(); con.close(); } catch(Exception e) { System.out.println(e); } any idea??
And when i used the CMD to compile i didnt get any errors & im able to execute. & i can retrieve the data, but when i insert something it is not being updated in access file.