title: Do we have transactions in MS-Access?
body: <p>I am developing a small desktop application using <strong>C#.NET and MS-Access</strong>. I don't have any prior experience of MS-Access. I want to know if we can use transactions in Ms-Access or not.</p>
  
  <p>I have the below mentioned situation.</p>
  
  <blockquote>
    <p>Insert in Tbl1<br> Insert in Tbl2</p>
  </blockquote>
  
  <p><strong>I want to insert in tbl2 only when insertion in tbl1 is successful. And if there is some exception during insertion in tbl2, I want to rollback the insertion in tbl1.</strong>
  <br>
  I know this can easily be achieved in sql-server, but in case of ms-access, How should I manage this.
  Please Help, Thanks in advance.</p>