In addition to what other said, NEVER specify work area by number or letter because it makes programs impossible to read and maintain. You can open tables/views in the first unused work area using 'IN 0' clause, select work area or close tables/views using it's alias.

use myview in 0
SELECT myview
...
USE IN myview
USE in mybasetable

>Hello
> I delete an already existing dbf file and recreated the file by new set of data using
>copy to (strbatch_num4) FOX2X where strbatch_num4 is the path and file name.
>within the loop if I again try to delete the file it gives me error "File in use and cannot be deleted". I created a view from this dbf file and close that view by using "USE in 7" as I open the view in workspace 7.
>Why can I delete for the first time and not the second time?
>
>Thanks
>Bharat