Hi

I have defined driver, connection,url , statement. All working fine. Even for SELECT statement I am being shown the records present in my DB table.

The problem is that when I am Inserting records and running the program it is showing no error or Exception but the records are not inserted (the application runs succesfully), What should I do?

I am using executeUpdate("INSERT INTO TABLENAME VALUES([I]VALUE1,VALUE2,VALUE3,.......VALUEn/I]n"));

And I am using MS-Access DB I have not to define the USER and PASSWORD Parameter. And also I have checked that the DB file is not readonly.

If a locking mechanism is implemented how to unlock it?

Thanks in Advance