title: Unrecognizable database format
body: <p>I am trying to connect to a remote Access 2010 database from a client system. </p>
  
  <p>My connection string is as follows:</p>
  
  <pre><code>Dim cnn As New ADODB.Connection
  cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\&lt;ipaddress&gt;\&lt;sharedfolder&gt;\&lt;databasename&gt;.accdb"
  </code></pre>
  
  <p>I get run time error</p>
  
  <blockquote>
    <p>Run-time error 2147467259  Unrecognizable database format</p>
  </blockquote>
  
  <p>How can i fix this ?<br>Or is there an alternate way of connecting to a remote database?</p>
  
  <p>I am currently trying ODBC but I do not see the Access drivers for some reason despite installing data access components. FYI the database is Access 2010 database. I am trying to connect from Excel 2007 vba code. I can access the shared folder with no issues.</p>