I am running a sub to 'snapshot' data from a pass-through query (which is slow) and store the results to a table. It is supposed to delete the table, then re-create it to be an updated snapshot of the pass-through query.
I know that before deleting the table I must close anything locking it. I only have one unbound form, and one subform on that which draws data from a query involving the table in question. I have a DoCmd.close action that closes the main form, but the line deleting the table still errors that it's 'in use by another person or process'.
How do I unlock it, is there more I should be doing other than closing the form?