>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.