>>>>>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.
>>
>>No, it should be a CLEAR ALL. As Jim B. indicated, there may be some outstanding unsaved data...if so, usually a clear all will cause a message to appear indicating this...
>
>Sorry, typo in my message. It should read CLEAR ALL. Does not work. Also for Your information: No transactions or buffering is been used.
>
>KR,
>Wim.

I am fairly confident that the reason your database is left open is that there are tables, possibly in other work areas left open. Watch your code in the debugger, and open the session window and look for any orphaned datasessions with tables in them.