title: "Unspecified error" while opening an ADODB connection
body: <p>I am facing <strong>"Unspecified error"</strong> in <strong>only one PC</strong> of my users.</p>
  
  <blockquote>
    <p>Run-time error '-2147467259 (80004005)':<br>
    Unspecified error</p>
  </blockquote>
  
  <p>I am running the below VBA code to open a connection to Access database located in network shared drive. But <strong>the code throws the error whenever it is trying to run the <code>.Open</code> statement</strong>.</p>
  
  <p>I thought it is a driver issue and installed Access 2007 Database engine in the user's PC and replaced Provider with "<code>Microsoft.ACE.OLEDB.12.0</code>" but it doesn't work.</p>
  
  <p>Code:           </p>
  
  <pre><code> Dim cn As ADODB.Connection
   Dim rs As ADODB.Recordset
   Dim retVal As Boolean
   Dim strSQL As String
   retVal = False
  
      On Error GoTo CatchError
       Set cn = New ADODB.Connection
  
       With cn
       .Provider = "Microsoft.Jet.OLEDB.4.0"
       .Properties("Jet OLEDB:Database Password") = Initialize.GetDBPwd 'returns pass
       .Open Initialize.GetDbConnectionString 'returns the network DB path
      End With
  </code></pre>