You are welcome. I got tripped up by that one myself.
Glenn
>hi,
>thank you very much, it works.
>
>>I suspect it is FoxUser.DBF. Try:
>>
>>Set resource off
>>
>>
>>Glenn
>>
>>>i have no tables, itry it with tables and without the same message,
>>>
>>>it is a small project ,
>>>i use it to convert excel sheet to .dbf and make operations and convert it again to excel,
>>>no need to keep it.
>>>
>>>thanks
>>>>>hi all,
>>>>>i try to delete via command button as below.it works at mydir(myform),but if i run it as .exe i got error message file is in use.
>>>>>
>>>>>CLOSE all
>>>>>ERASE *.dbf
>>>>>ERASE *.cdx
>>>>>ERASE *.fpt
>>>>>ERASE *.xls
>>>>>
>>>>>thanks
>>>>
>>>>That means that probably one of the tables is open, and you must close some table first.