title: Calling Access Macro from VB.NET problems
body: <p>I call an Access macro from vb.net like so:</p>
  
  <pre><code>Acc.DoCmd.RunMacro("Macro1")
  </code></pre>
  
  <p>The Macro in Access has many OpenQuerys and Msgbox with a message saying "data done" at the end.</p>
  
  <p>When I execute the macro from vb.net, it shows the data done message and then done. However, when I analyse the table's to see if data has been appended, it hasen't.</p>
  
  <p>When I run the same macro from within Access, it works fine. It does show many messages like "You are about to run an append query that will modify data in your query" and I hit yes and does take slightly longer, but it does do it. 
  In VB.NET, the only message I get is the final messagebox.</p>
  
  <p>I have also tried:</p>
  
  <pre><code>Acc.SetOption("Confirm Action Queries", 0)
  Acc.SetOption("Confirm Document Deletions", 0)
  Acc.SetOption("Confirm Record Changes", 0)
  </code></pre>
  
  <p>before executing the macro from within VB.NET but to no avail. Still works the same.</p>
  
  <p>Is there a way to fix it?</p>
  
  <p>EDIT: My Access DB is mdb file</p>