title: How to fix error "Cannot update. Database or object is read-only." Excel Database Automation Anywhere
body: <p>I am accessing an excel file stored on a shared drive for now a couple of months without errors. All of a sudden, we have this issue popping out: 
  <code>Cannot update. Database or object is read-only.</code> </p>
  
  <p>My original connection string looked like this: </p>
  
  <p><code>Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&lt;FileName&gt;";Extended Properties="Excel 12.0 Xml;HDR=Yes;"</code>. </p>
  
  <p>I have tried the following one: </p>
  
  <p><code>Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&lt;FileName&gt;";Extended Properties="Excel 12.0 Xml;HDR=Yes;Readonly=0;"</code> </p>
  
  <p>and </p>
  
  <p><code>Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&lt;FileName&gt;";Extended Properties="Excel 12.0 Xml;HDR=Yes;READONLY=FALSE;"</code> </p>
  
  <p>but nothing provides good results.</p>
  
  <p>I need to connect to this excel workbook and get the data in order to perform some business critical process, but nothing works so far as it always provides me with the mentioned error.</p>
  
  <p>Any recommendation?</p>