>>
>>I am new to VFP but in other xbase languages we had something like this
>>
>>nArea = select(0) && Get the next available work area number
>>for i = 1 to (nArea -1) && -1 because we did not open anything in nArea
>> select(i) && select that workarea
>> use && Close the workarea
>>endfor
>>
>>Hope this helps you think of something you could use.
>
>Hello Cecil & Henry,
>
>That is not necessary in VFP. CLOSE DATABASE ALL closes all tables (including free tables) in the current session. If there are multiple sessions, you must iterate through them as Larry has suggested.

Thank you for your guidance Steve. Alsways appreciated.

- Ravi