>Hi Del
>
>>If you own SDT, there is a method of the utility class named CloseOpenedTables(). I've used it quite a bit over the years to do just this.
>
>No, I don't. Thanks a lot for the response. If I may and if I can ask, what is the general logic for this method, does it simple do a USE IN to the table name passed to it? or is it more complex than that?
Here's the heavy thing that I use when I must - don't do this while you have forms open:
Procedure closeall
For ii=1 To Asessions(aa)
Set DataSession To (aa[ii])
Close Databases All
Endfor
Set DataSession To 1
Also, instead of Close Databases All, you could have a loop through the whole array created by aUsed(), check for buffering of each alias, and tablerevert() if buffered, then close it.