title: How do I extract table names from MS Access database using ADO
body: <p>i tried using this code :</p>
  
  <pre><code>OleDbConnection c = new OleDbConnection(con);
  string SQLS = "SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name Not Like 'MsyS*' AND MSysObjects.Type=1 ORDER BY MSysObjects.Name";
  OleDbDataAdapter da = new OleDbDataAdapter(SQLS, c);
  DataTable dt = new DataTable();
  da.Fill(dt);
  dataGridView1.DataSource = dt;
  </code></pre>
  
  <p>But i got  this exception:</p>
  
  <blockquote>
    <p>Record(s) cannot be read; no read permission on 'MSysObjects'.</p>
  </blockquote>
  
  <p>Now, i need to transfer the entire ms-access database to mysql programmaticaly, thus i need the database names. How do I work my way around this error?  </p>