title: Msaccess connectivity with java
body: <p>Iam trying to connect java with ms-access i get following errors</p>
  
  <pre><code>java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.net.URLClassLoader.findClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at msaccesssample.sample.main(sample.java:11)
  </code></pre>
  
  <p>Here is my java code </p>
  
  <pre><code>package msaccesssample;
  import java.sql.*;
  public class sample {
  
  
      public static void main(String[] args)
      {
          try
          {
  
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con = DriverManager.getConnection("jdbc:odbc:satish");
                Statement st = con.createStatement();
                ResultSet rs=st.executeQuery("select * from sample");
  
          }
          catch(Exception e)
          {
              e.printStackTrace();
  
  
          }
  
      }
  
  }
  </code></pre>
  
  <p>Actually i created satish as DSN and added database name as test.accdb.the problem is already asked many times in forum but i dont know whelther its a driver problem or programming problem.my system is 64 bit with windows 8 and my odbc is 32 bit.I couldn't get the ms access drivers in 64 bit.Is there any way to load ms access drivers in 64 bit?????? </p>