In Access Macro, when you OpenQuery, you actually run the Query ?
For example, you already created a Query, so why in Access Macros, do you have it script to OpenQuery, and then Close it again with CloseWindow ?
Is it to open the query and update it ?
I can understand why there is CopyObject, because you want to copy the source to a new table and you have these two table set up.
I don't get why there is OpenQuery (example read only) and then closing it again. Is it to update the query, sorry for reiterating it.
Thanks !!