title: ADOX Multiple-step OLE DB operation generated errors
body: <p>I have to make a program that turns off all Unicode compression and all "allow zero length" in an access database (.mdb) . </p>
  
  <p>The method for turning off Allow Zero Length works very well. However, the method for turning off Unicode compression does not work at all and returns the following exception:</p>
  
  <blockquote>
    <p>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.</p>
  </blockquote>
  
  <p>Any clue on how to solve this ? </p>
  
  <pre><code>private void TurnOffUnicodeCompressionInField(ADOX.CatalogClass catalogClass, String tableName, String field)
  {           
      ADOX.Column column = catalogClass.Tables[tableName].Columns[field];
      ADOX.Property prop = column.Properties["Jet OLEDB:Compressed UNICODE Strings"];
      prop.Value = true;
  }
  
  private void TurnOffAllowZeroLengthInAllFields(ADOX.CatalogClass catalogClass, String tableName)
  {
      foreach (ADOX.Column column in catalogClass.Tables[tableName].Columns)
          column.Properties["Jet OLEDB:Allow Zero Length"].Value = false; 
  }
  
  private void MyButton_Click(object sender, EventArgs e)
  {
      String filePath = "";
      OpenFileDialog ofd = new OpenFileDialog();
      DialogResult result = ofd.ShowDialog();
  
      if (result == DialogResult.OK)
      {
           filePath = ofd.FileName; 
           ADOX.CatalogClass catDatabase = new ADOX.CatalogClass();
           catDatabase.let_ActiveConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath);
  
          // SoftwareTable 
          TurnOffAllowZeroLengthInAllFields(catDatabase,"Software"); 
          TurnOffUnicodeCompressionInField(catDatabase, "Software", "Description");
          TurnOffUnicodeCompressionInField(catDatabase, "Software", "Name");
      }                      
  }
  </code></pre>