>>>>The Following problem occurs:
>>>>
>>>>I open a table (in a database) for browsing or something. Then i issue a USE to close the table. (that works fine) Then i close the database with CLOSE DATABASES. Then ... The database is still open (i Try to copy the database after this, and it fails. Even the explorer can't copy it so it must be open.) I even tried CLOSE DATABASES ALL and CLOSE ALL. It does not work. I have to close fox and reopen it for it to work.
>>>
>>>CLOSE DATA only shuts the currently SET dbc. CLOSE DATA ALL usually shuts all dbcs and contained tables, but occasionally I've had to issue a CLEAR ALL to really get everything closed...
>>
>>Even a close all does not close the database. It seems as if this one is a bug. I've tried about all possibilities, but no luck so far.
>>
>>Thanks in advance for any help.
>
>Hi Wim
>I too have this problem, I often receive a message from Visual Source Safe stating it cannot operate on open files ( the culprit is always a VFP Database )
>Regards
>Pete Kane

I have much luck with

cancel
clear all
close data all
And if your using the Project manager, be sure to close the database in there also (no treeview, pick the close button)