title: Data Macros in MS Access not working with SQL-Queries from JAVA
body: <p>I created a Database (MS Access) and a frontend with JavaFX.</p>
  
  <p>In one table, I implement a data macro, which trigger INSERT Events in a different column (CurrentUser()-Function). I tested the data macro in different ways (created a row directly in MS Access, created a VBA-Code with an SQL-Insert-Query), and any time my Trigger works.</p>
  
  <p>Also my Java-Frontend is doing fine (SQL INSERT to MS Access). <strong>But the Problem is: The data macros doesn't work on this way.</strong></p>
  
  <p>I suppose, there's a correlation between the backend-update from MS Access and the data macros, because any time when I do an SQL-Insert-Command with my JavaFX-Frontend, MS Access didn't show me the new Row in the table (Refresh of the table can't fix this issue). I need to close MS Access first to see my new table-inserts (certainly without a Trigger-insert :-)).</p>
  
  <p>Is there any possibility to fix the problem? </p>
  
  <p>I would appreciate any help! Thanks</p>