hello, am trying to access the DB like you said above but i keep getting the following message: with

Connection databaseConnection = DriverManager.getConnection("jdbc:odbcriver={MicroSoft Access Driver (score.mdb)};DBQ=//www.monaghan-c.co.uk/java/score.mdb");

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

or change the {MicroSoft Access Driver (score.mdb)} to {MicroSoft Access Driver (*.mdb)} i get
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Disk or network error.

The db is at that address and host supports the db. Please could any one help me out with this problem . the full code for the class is below:


import javax.swing.JOptionPane;




import java.sql.SQLException;
import java.lang.*;
import java.sql.*;


public class Main
{

public static void main(String[] args)
{
try {



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

// String sourceURL = new String("jdbc:odbc:score");




Connection databaseConnection = DriverManager.getConnection("jdbc:odbcriver={MicroSoft Access Driver (score.mdb)};DBQ=//www.monaghan-c.co.uk/java/score.mdb");

Statement statement = databaseConnection.createStatement();
ResultSet score = statement.executeQuery("SELECT User-Name, Score FROM scoreboard");

while(score.next()) {
System.out.println(score.getString("User-Name")+" "+score.getString("Score"));
}

}catch(ClassNotFoundException cnfe) {
System.err.println(cnfe);
}catch(SQLException sqle){
System.err.println(sqle);

GameControl.newGame();

}
}

}


thanks for your time

chris mon