Connecting Access 2000!?

Hi !

I'm experiencing problem with my current Access connection.

It's working for a while but causes an error.

I'm using this code:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;

String url = "jdbc:odbc:DNS_name" ;

Connection con = DriverManager.getConnection( url , "" , "" ) ;

Statement stmt = con.createStatement();

ResultSet itom = stmt.executeQuery( "SELECT * FROM TABLE" ) ;

Could you help me by giving me an other way to connect my database.

Another driver?

Another code syntax?

Thanks...

[592 byte] By [sylvain.barbot] at [2007-9-26 3:50:11]