Updated/Refreshing an Access query:

The process that I’m trying to automate requires for an existing Access Query to be updated (I don’t need to retrieve any data, just refresh the data within existing query).

  1. Which is the correct activity to use ‘Execute Non Query’ or ‘Execute Query’?
  2. What is the correct syntax for ‘sql query’ to update/refresh an existing query within an Access Database?