Detect if table is in use.

[stephen81]

I've got a temporary table which I'm using as the source for a mail merge. I need to either delete the table when it is no longer being used for the mail merge or be able to test to see if it is being used at that moment.
Can anyone point me in the right direction?

 

[stephen81]

Is there a way to only display the message once the mail merge has completed though? Or should I just display it and hope they don't flick back to the access window and see the message before they've finished the mail merge?

 

[ghudson]

I've got a temporary table which I'm using as the source for a mail merge. I need to either delete the table when it is no longer being used for the mail merge or be able to test to see if it is being used at that moment.
Can anyone point me in the right direction?

I trust that you are not sharing that temp table with multiple users.

Why not delete the contents of the temp table at the beginning of your procedure for the mail merge? This will do just that...

CurrentDb().Execute "DELETE * FROM [YourTableNameHere]"