>Nadya,
>The easiest way to do this is to add a session object at the top of your program. It will create a private datasession for the prg. At the end, release the object and the tables will go away.
>
>Just another thought.
>
Yes, it seems to be the easiest way. If I leave this code to be a program, I'll use this idea. Currently I implemented Daniel's code. It works like a charm.
Thanks.
>>>Nadya:
>>>
>>>Please send reply if you are still pursuing this idea. I've got Friday off and plan to give it a shot if it's worth something to somebody (I'm curious to see how difficult it is).
>>>
>>>Thanks,
>>>Daniel
>>
>>Hi Daniel,
>>
>>I think your idea is simpler, than Larry's. Actually, while ago I wrote similar program for closing all open databases... Currently I put this problem aside, because I have to calculate statistics first. I already found, that the algorithm I tried to use (see thread with Ko Wisse) is quite cumbersome and inefficient :( I have to re-write it. I have to write couple more statistics programs, then I'll try to generalize them and create form. If it would be a form, I will not need CloseView program at all (all tables would close automatically). This problem arises only because currently I use programs and I want to clean up after myself.
>>
>>Thanks again for you help.
If it's not broken, fix it until it is.
My Blog