title: Select And Update within same query in MS Access & C#
body: <p>I would like to Select &amp; Update the same record in access in same query from c# application. Something like-</p>
  
  <pre><code>int personId=command.ExecuteScalar(
    "Select Top 1 PersonId From Persons where IsLocked=false 
    AND UPDATE THE SELECTED ROW WITH IsLocked=true");
  </code></pre>
  
  <p>I must require the PersonId value which is being selected &amp; updated in my code.</p>
  
  <p>I saw some questions in SO, but those are not what I actually want.</p>
  
  <p>Any help?</p>