I want to connect applet with Ms-Access. For example, I want to add, update, insert and delete the records in the MS-Access thru Applet or Swing. I had searched this topic in this forum, but it is not too clear to clear my doubts. To write a program in Applet to connect with JDBC(MS-Access), what are all the steps needs to be done. What is Policytool? Any sample coding connecting applet with MS-Access will be helpful.
basically what u want to do is connect to a DB from the applet right?
an Applet will restrict certain operations to be done on the local file system, since the applet will be executed in a sand box. However, there is no restriction for an applet to connect to a DB which is located in the local machine AFAIK. (so no need to worry abt any security policies. ) The steps are the same as for the case ur writing a Java Swing client to connect to a DB using JDBC.
First load the correct driver, Create the connection object, blah, blah, blah
Hope i answered u. Get back if ur not clear. Good Luck
1 Class.forName("") The string which is passed in this is the url of jdbc-odbc bridge driver 2 getConnection(": :testdatasource") this is the dsn u would create for ur application, which will point ur ms access database....
3 U can create the same code for an applet...as this code is with swing application..