title: Ms Access: Record(s) cannot be read; no read permission on [table]
body: <p>i wrote script for downloading mdb files and reading them due OLEDB provider. All works fine, but if i try to read from table, it throws an exception:</p>
  
  <p><strong>Ms Access: Record(s) cannot be read; no read permission on tblMytable</strong></p>
  
  <pre><code> var cmd = new OleDbCommand("SELECT * FROM tblMytable", conn);
   var reader = cmd.ExecuteReader();
  </code></pre>
  
  <p>I changed permissions directly in Ms Access for user "administrator" and it works. But the problem is, that this script musst run twice a day and it downloads about 20 files. So its impossible manually changing permissions.</p>
  
  <p><strong>Is it possible to change read rights for a table programatically?</strong> </p>
  
  <p>Thanks a lot for any ideas!</p>