title: Access DB: Operation must use an updateable query
body: <p>I am running an ISS server, i have an access file located in C:\WCF\Access\
  I am using this query to insert something:</p>
  
  <pre><code>@"INSERT INTO Arbejdsindsats (MedarYdelID, StartTid, SlutTid) VALUES ('" + medarYdelID + "', '" + startTid + "', '" + slutTid + "')";
  </code></pre>
  
  <p>The full code is:</p>
  
  <pre><code>public String GemArbejdsIndsats(String medarYdelID, String startTid, String slutTid)
          {
              try{
              con.Open();
              String command = @"INSERT INTO Arbejdsindsats (MedarYdelID, StartTid, SlutTid) VALUES ('" + medarYdelID + "', '" + startTid + "', '" + slutTid + "')";
              cmd.CommandText = command;
              cmd.ExecuteNonQuery();
              con.Close();
  
  
                  return "success: medarydelid: " + medarYdelID + " startTid: " + startTid + " slutTid: " + slutTid;
              } catch(Exception e)
                  {
                      String k = e.Message;
                      return k;
                  }
          }
  </code></pre>
  
  <p>The problem is this error:</p>
  
  <blockquote>
    <p>Operation must use an updateable query</p>
  </blockquote>
  
  <p>When i test locally on my own machine, it works fine. Just not in the IIS.</p>
  
  <p>The weird thing is that there's a laccdb file. it wont go away. Maybe the database is locked and thats why i cant update it?</p>
  
  <p>The permission should not be a problem:</p>
  
  <p><a href="http://img.ctrlv.in/50c0dbf8670d8.jpg" rel="nofollow noreferrer">img http://img.ctrlv.in/50c0dbf8670d8.jpg</a></p>