title: ODBC connection to Access database in 64-bit Windows
body: <p>I am using <a href="https://www.youtube.com/watch?v=mJcB8KbqyPk" rel="nofollow noreferrer">this tutorial</a> to create a database connection from a java application to a Microsoft Access 2010 database. The tutorial creates a system dsn in windows, and then connects to that system dsn using the following line of java code:</p>
  <pre><code>Connection conn = DriverManager.getConnection(&quot;jdbc:odbc:DSN_NAME&quot;);   
  </code></pre>
  <p>The problem is that, when I click the link to add a new system dsn at:</p>
  <pre><code>Control Panel --&gt; System and Security --&gt; Administrative Tools --&gt; Data Sources (ODBC) --&gt; (System DSN Tab) --&gt; (Add.. button)  
  </code></pre>
  <p>It does not give me an option to choose Microsoft Access as the database type.  Instead, the options given are shown in the following printscreen:</p>
  <p><a href="https://i.stack.imgur.com/sAVO3.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sAVO3.gif" alt="" /></a></p>
    
  <p>I am wondering if this is a driver issue, where I need to download something.  Or if it is a configuration issue.  I am using Windows 7.  Can anyone show me how to fix this so that I can create the System dsn required to complete this tutorial?  Or at least show me another easy way to connect to a Microsoft Access database from java?</p>