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.