title: Could not find installable ISAM error in VBA for .accdb file
body: <p>I am trying to connect MS Excel VBA program to MS access database.
  While I am trying to access *.mdb files it is working properly in both local drive and share drive.
  While accessing *.accdb file I am able to connect in local drive.
  But while trying to connect .accdb file in shared drive i am getting the error as "Could not find installable ISAM".</p>
  
  <p>Here is the code I am trying,</p>
  
  <pre><code>strDBPath = "\\shared drive path\Database.accdb"
  
  Set objConnection = New Connection    
  
  With objConnection
      .ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;" &amp; _
          "Data Source=" &amp; strDBPath &amp; ";" &amp; _
          "Persist Security Info=False" &amp; ";" &amp; _
          "PWD=" &amp; pass
          .Open
  End With
  </code></pre>
  
  <p>Please provide a resolution to the query.</p>
  
  <p>Regards,
  Susanta Kumar Patra</p>