title: Working with OLEDB connection on Office 2013 64 bit
body: <p>I know there are a number of threads related to this. However, none of them seemed to solve my problem. I am putting down my exact problem here. Can someone help me with this?</p>
  
  <p><strong>Environment</strong> - Windows 7 64 bit, Office 2013 64 bit</p>
  
  <p><strong>Automation</strong> - A macro in VBA in Excel that will import some data to an .mdb file by connecting to it using the below mentioned driver</p>
  
  <p>Issue - Runtime error 3706, provider cannot be found. it may not be properly installed</p>
  
  <p><strong>Attempt 1</strong> - I checked the error code online and most of the threads pointed to syntax errors and way of connecting. I tried implementing the suggestions but there was no impact</p>
  
  <p><strong>Attempt 2</strong> - I then found that this is because it was trying to use old driver with 64 bit office. Therefore, I then tried installing the most popular suggestion - <a href="http://www.microsoft.com/en-us/download/details.aspx?id=13255" rel="nofollow">http://www.microsoft.com/en-us/download/details.aspx?id=13255</a>
  This also didn't work</p>
  
  <p>Code - </p>
  
  <pre><code>database_path = Application.ActiveWorkbook.path &amp; "\" &amp; "mydb.mdb"
  Set cn = CreateObject("ADODB.Connection")
  With cn
      .Provider = "Microsoft.Jet.OLEDB.4.0"
      .ConnectionString = "Data Source=" &amp; database_path
  End With
  cn.Open
  </code></pre>
  
  <p>Any solution is welcome as long as it works on all - office 2007, 2010 and 2013.</p>
  
  <p>Thanks!</p>