title: How to debug a docmd.transferdatabase statement that does not work (no compiler error, simply does not xfer the data)
body: <p>I'm a new VBA programmer trying to append everything from a TableA in Database1 to a TableA in Database2. I wrote a DoCmd.TransferDatabase statement called in an access macro. The statement executes without any error, but it does not transfer the data. </p>
  
  <p>-->RUNS IN Database1...</p>
  
  <pre><code>DoCmd.TransferDatabase acExport, "Microsoft Access", "I:\Database2.mdb", acTable, 
  "TableA", "TableA", True
  </code></pre>
  
  <p>I don't really know how to debug this, because the statement is executing without an error from the compiler and there is no way to "see" what happens once it fires. </p>
  
  <p>-The path/table names are correct because if they are wrong, the compiler throws an error (learned the hard way...!) </p>
  
  <p>What should I do to debug?</p>