title: Multiple-step OLE DB operation generated errors" when opening ADO connection
body: <p>I have this connection string</p>
  
  <pre><code>strConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\mydb.accdr;Persist Security Info=False;"
  </code></pre>
  
  <p>When I try to open the connection, I get this error:</p>
  
  <blockquote>
    <p>Multiple-step OLE DB operation generated errors" </p>
  </blockquote>
  
  <p>when opening ADO connection.<br>
  I tried all possible solutions found on Google, but no success. Registry is fine.</p>
  
  <p>Any advice?</p>
  
  <p>Here is how I use the code: (<code>cn</code> is a global <code>ADODB.Connection</code>)</p>
  
  <pre><code>Set cn = New ADODB.Connection
  cn.Open strConnect, "Admin", ""
  </code></pre>
  
  <p>PC is running windows XP with no MS Office installed. </p>
  
  <p><strong>EDIT</strong></p>
  
  <p>I have tested the connection string outside of the application and it works fine. just doesn't want to connect when opening the connection from code.</p>
  
  <p>Also had a look at <a href="http://www.adopenstatic.com/faq/80040e21.asp" rel="nofollow">http://www.adopenstatic.com/faq/80040e21.asp</a>, seems my issue is <strong>scenario 2</strong> but still no idea how to fix it.</p>
  
  <p>Other references I looked at, but where not helpful are:
  <a href="https://support.microsoft.com/en-us/kb/269495" rel="nofollow">https://support.microsoft.com/en-us/kb/269495</a></p>