When I run it on web page and do any data entry. It doesnt give me any error but doesnt even update data in the MS Access database
Are you sure? Do you have the Java console window open in your browser? Put some System.out.println statements in your code so that you can see the code's progress, and make sure there is nowhere you catch an exception only to squelch it:
-
} catch(SomeException e) {
-
//silence
-
}
Generally speaking, connecting to a database from an applet is a bad idea, because most of the time, your database server and your web server are different machines, while applets are restricted to only connecting back to the web server.
I'm biased because I dislike applets, but I would rewrite this as a proper web application with servlets and JSP.