applet permissions problem

[Anon]

I have pasted my code below. My problem is that everytime I press the accept button on my applet window it gives me this error message:

Exception: access denied (java.lang.RuntimePermission accessClassInPackage.sun.j
dbc.odbc)

when what it is supposed to do is enter the coffee table values specified into the coffee table. I have tested the applet without the jdbcodbc part and it works fine and i have also tested entering the coffee table values wihtout the applet and that works perfect too. But when I put them both together it gives me the above error. I have specified permissions for the applet as well by going into
java.home/jre/lib/securiy/java.policy
and I have added permission for the applet to be able to write to the grn.mdb database file but i don't think it recognises it or something.

Please tell me what I need to do to avoid getting this error and getting my desired result.

I would really appreciate your help.

Akansha.

[Anon]

My code is :
import javax.swing.;
import java.awt.event.;
import java.sql.;
import java.awt.;
//import java.io.*;

public class MyTest2 extends JApplet
{
JPanel panel;
JLabel labelGRNDate;
JLabel labelRefFrom;

JTextField textGRNDate;
JTextField textRefFrom;

JButton buttonAccept;
GridBagLayout gl;
GridBagConstraints gbc;

public void init()
{
	gl = new GridBagLayout();
	gbc = new GridBagConstraints();
	panel = (JPanel)getContentPane();
	panel.setLayout(gl);

	labelGRNDate = new JLabel("GRN Date");
	labelRefFrom = new JLabel("Ref From");

    	buttonAccept = new JButton("Accept");
	textGRNDate = new JTextField(6);
	textRefFrom = new JTextField(4);

	gbc.anchor = GridBagConstraints.NORTHWEST;

	gbc.gridx = 1;
	gbc.gridy = 1;
	gl.setConstraints(labelGRNDate,gbc);
	panel.add(labelGRNDate);

	gbc.gridx = 2;
	gbc.gridy = 1;
	gl.setConstraints(textGRNDate,gbc);
	panel.add(textGRNDate);


	gbc.gridx = 1;
	gbc.gridy = 2;
	gl.setConstraints(labelRefFrom,gbc);
	panel.add(labelRefFrom);

	gbc.gridx = 2;
	gbc.gridy = 2;
	gl.setConstraints(textRefFrom,gbc);
	panel.add(textRefFrom);


	gbc.gridx = 9;
	gbc.gridy =10;
	gl.setConstraints(buttonAccept,gbc);
	panel.add(buttonAccept);
	dataAcception dataButton = new dataAcception();
	buttonAccept.addActionListener(dataButton);

}

class  dataAcception implements ActionListener
{
	public void actionPerformed(ActionEvent e)
	{
		Object obj = e.getSource();
		if (obj == buttonAccept)
		{
			String url = "jdbc:odbc:Noorderwind";

			String var1 = "Columbian";
			float var2 = 7.9f;
			int var3 = 999;
			int var4 = 500;
			int var5 = 77;
			Connection con;
			Statement stmt;
			String query = "select COF_NAME, PRICE from COFFEES";
			try 
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");



				con = DriverManager.getConnection(url);
				stmt = con.createStatement();								
				stmt.executeUpdate("insert into COFFEES values('" + var1 + "', '" + var5 + "', '" + var2 + "', '" + var3 + "', '" + var4 + "')");	



				stmt.executeUpdate("insert into COFFEES values('French_Roast', 00049, 8.99, 0, 0)");
				stmt.executeUpdate("insert into COFFEES values('Espresso', 00150, 9.99, 0, 0)");
				stmt.executeUpdate("insert into COFFEES values('Colombian_Decaf', 00101, 8.99, 0, 0)");
				stmt.executeUpdate("insert into COFFEES values('French_Roast_Decaf', 00049, 9.99, 0, 0)");
				ResultSet rs = stmt.executeQuery(query);
				System.out.println("Coffee Break Coffees and Prices:");
				while (rs.next()) 
                    		{
					String s = rs.getString("COF_NAME");
					float f = rs.getFloat("PRICE");
					System.out.println(s + "   " + f);
				}

				stmt.close();
				con.close();

			} 
            		catch(Exception ex) 
            		{
				System.err.println("Exception: " + ex.getMessage());
			}
		}
	}

}

}