title: open and modify mdb file from azure blob
body: <p>I have an mdb file in storage azure blob, i must read and modify that file without download it with some query in c# and i must show info in a web page(javascript, html).</p>
  
  <pre><code>[ViewItem(nameof(StorageRetriveDB), "Files", "GET - StorageRetriveDB")]
  public List&lt;string&gt; StorageRetriveDB([FromUri] string id)
  {
      List&lt;string&gt; ListboxItems = new List&lt;string&gt;();
      string url = "blobname";
      var storageAccount =
          CloudStorageAccount.Parse(ConfigurationManager.AppSettings["AzureStorageConnectionString-1"]);
      CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();
      CloudBlobContainer container = blobClient.GetContainerReference(url);
      CloudBlockBlob blob = container.GetBlockBlobReference("mydb.mdb");
      if (blob.Exists())
      {
          using (var stream = blob.OpenRead())
          {
              string connString = @"Driver={Microsoft Access Driver (*.mdb)};Dbq=LINKTOMYAZUREBLOBSTORAGE/mydb.mdb";
              using (OdbcConnection connection = new OdbcConnection(connString))
              {
                  connection.Open();
                  OdbcDataReader reader = null;
                  OdbcCommand command = new OdbcCommand("SELECT * from tbVariablesMap", connection);
                  reader = command.ExecuteReader();
                  while (reader.Read())
                  {
                      ListboxItems.Add(reader[0].ToString() + "," + reader[1].ToString() + "," +
                                       reader[2].ToString() + "," + reader[3].ToString());
                  }
              }
          }
      }
  
      return ListboxItems;
  }
  </code></pre>
  
  <p><code>connection.Open();</code> causes a crash, with local db it works but in azure blob storage it doesn't work!</p>