title: Check access database if table exists
body: <p>Is there a way to check if table exists in mdb file? Im using PHP and ADOdb connection to connect.</p>
  
  <p>here's my code</p>
  
  <pre><code>$conn = new COM("ADODB.Connection");
  $conn-&gt;open("DRIVER={Microsoft Access Driver (*.mdb)}; PWD=somepassword; DBQ=".dirname(__FILE__)."\filename.MDB;");
  if (table exists){ \\ where i need the code to check
      $createtable = $conn-&gt;execute("CREATE TABLE $tblname (fieldsample CHAR(1))");
  }else{
      $insertqry = $conn-&gt;execute("INSERT INTO $tblname (field) VALUES (value)");
  }
  </code></pre>
  
  <p>Been browsing all day for the syntax but all I've seen so far are all for VB and ASP.</p>