DATABASE APPLET

[MR Thakkar]

how do i connect applet to datbase of ms-access.

[Bosun Bello]

You can do it the same way you do it with a java application, with minimal changes. As long as th applet and the DB are located on the same server. There is an example at Sun's site. You can also search this forum. It has been discussed a number of times.

[MR Thakkar]

i have tried it no wbut i get the below error.
access denied(java.lang.RuntimePermission accessClassInPackage.sun.jdbc.odbc)
MY CODE
--------

try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=question.MDB","","DbPass1");
    Statement st=con.createStatement();
    int aq=(int)(Math.random()*5);
    ResultSet rs=st.executeQuery("SELECT * FROM question WHERE question LIKE '"+aq+"%"+"'");
    while(rs.next()){
        System.out.print(rs.getString(1));
    }
}catch (Exception n){g.drawString(n.getMessage().toString(),30,40);}

[ Edited by Dave to format code and fix smilies ]
[ May 15, 2002: Message edited by: David O'Meara ]

[honey singh]

this is because of the sandbox of the explorer,as you don't have the specific privileges to do this action..It is always a problem with the applet to do this... so what you have to do is to use the policy tool and using this grant the permissions for this purpose...
u need to study for this on the following link
http://java.sun.com/j2se/1.4/docs/tooldocs/solaris/policytool.html
try this out..it must work..