title: Excel VBA Database connection error: Cannot open database '(unknown)'
body: <p>I am trying to connect to Access Database using ADO DSN.</p>
  
  <pre><code>StrPath = Sheets("Sheet1").Range("DB_location")
  strCon = "DSN=MS Access Database;DBQ=" &amp; StrPath &amp; ";"
  
  Set con = New ADODB.Connection
  con.Open strCon
  </code></pre>
  
  <p>I can connect to DB without any problem on my machine. However, when I tried running this exact macro on another PC, I ran into this issue on the last line:</p>
  
  <p><a href="https://i.stack.imgur.com/MZxai.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MZxai.png" alt="enter image description here"></a></p>
  
  <p>I assumed it was due to Database Engine, but installing "Microsoft Access Database Engine 2010 Redistributable" from Microsoft's website didn't solve this problem. All the necessary references in VBA editor are present. 
  There is no problem with DB or the macro, as I checked on a different PC, but this specific computer runs into this problem.</p>