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).
- Which is the correct activity to use ‘Execute Non Query’ or ‘Execute Query’?
- What is the correct syntax for ‘sql query’ to update/refresh an existing query within an Access Database?