title: PDO connect to .accdb on network
body: <p>I have an access database which I would like to CRUD with PDO.  When My database is stored on <code>C:\\wamp\\www\\test.accdb</code> I can connect.  However, the database I am interested in is stored on our office server, at <code>\\server1\abc\123\test.accdb</code> .
  \server1 is mapped to drive z:\ on my computer.  </p>
  
  <p>My code looks like this (verbatim)</p>
  
  <pre><code>&lt;?php
  //attempt 1
  $file = "\\server1\\abc\\123\\test.accdb";
  $dbh = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb , *.accdb)};Dbq=$file");
  
  //attempt 2    
  $file = "Z:\\abc\123\\test.accdb";
  $dbh = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb , *.accdb)};Dbq=$file");
  ?&gt;
  </code></pre>
  
  <p>both of these give me error:</p>
  
  <blockquote>
    <p>SQLSTATE[HY024] SQLDriverConnect: -1023 [Microsoft][ODBC Microsoft
    Access Driver] '(unknown)' is not a valid path. Make sure that the
    path name is spelled correctly and that you are connected to the
    server on which the file resides.</p>
  </blockquote>
  
  <p>I am indeed connected to the server. Does anyone here have some wisdom to share?</p>