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