That would be the point. Yup.

>close all does it but of course closes the project manager too.
>
>>CLOSE ALL should handle it. <g>
>>
>>But I agree with Stacy about the potential for another datasession hanging around. Open the datasession window and see what's really going on.
>>
>>>Yes, that seems to be what's happening. Is there a way to force it closed?
>>>
>>>>If the data is listed in your project, the PM can keep them open.
>>>>
>>>>Dan
>>>>
>>>>>Oops! I should have said "If I exit and then restart VFP. . . " Its a prg that I run from the run button in proj manager.
>>>>>
>>>>>>Where do you run code after exiting VFP? Separate application?
>>>>>>
>>>>>>>After running some other code which uses these tables, the following code produces an error on the first use stating the file is not available. If I exit VFP and then run the code it works OK. How can I force a close to make sure the tables are available?
>>>>>>>
>>>>>>>

>>>>>>>close tables all
>>>>>>>close databases all
>>>>>>>set exclusive on
>>>>>>>
>>>>>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\rawdata2005 in 0 alias rawdata2005
>>>>>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\history in 0 alias history
>>>>>>>use \\tpdfiles\data\dfreeman\trp\data\surveys\companyinfo in 0 alias companyinfo
>>>>>>>