Is it possible with VBA to delete a stored query after right after closing the query?
How would I attack this problem.
Thanks!
- Josh
Is it possible with VBA to delete a stored query after right after closing the query?
How would I attack this problem.
Thanks!
- Josh
You could use VBA to actually define and run the query from a variable. From that point there is no actual 'stored' query.
Alternatively you could run a macro that fires the query, then in the macro have a delete query object defined.
Thanks! I searched through the query definitions, deleted the query def, and then re-executed.