title: How to connect java to Ms Access 2010?
body: <p>Does anyone have any ideas of how to connect Access 2010 to java jdbc. I use this method, but when I call it, it doesn't work:</p>
  
  <pre><code>public void loadDb(){
     try{
         Class.forName("sun.jdbc.JdbcOdbcDriver");
         File f = new File(System.getProperty("user.dir"))       
         con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","","");
         st = con. createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
     }catch(ClassNotFoundException e){e.printStackTrace();
     }catch(SQLException e){e.printStackTrace();}
  }
  
  //con and st are already defined
  </code></pre>