>I have a weird, and persistent problem. A free table that doesn't want to close. Here is code:
>
>

>IF mwebenable	
>	thiswebfile=&mwebpath+'jobsweb.dbf'
>	thiswebfile1=&mwebpath+'applweb.dbf'
>	USE &thiswebfile1 IN 0
>	SELECT applweb
>	SET ORDER TO 1 
>	IF !USED('&thiswebfile')
>		USE &thiswebfile IN 0
>	ENDIF 
>	SELECT jobsweb
>	SET ORDER TO 1
>	SEEK mponum
>        ....
>        ....
>	SELECT applweb		
>	USE IN applweb
>	SELECT jobsweb
>	USE IN jobsweb
>ENDIF
>

>
>NO problems with 'applweb.bdf' at all, but run the prg more than once, and 'jobsweb.dbf' comes up unclosed. And I have tried all combos of Select and Use that I can think of.
>
>I can't use 'close tables all', as that will close the stuff in the DE, too, which is NOT wanted.
>
>What else can I do? ANY ideas will be greatly appreciated!
>

John,

First: like others: get rid of those & and use naming conventions.
Second: what is the value of mwebpath and why do you use a different path for web as for non-web.
You want file applweb.dbf to be closed, apart from the fact why? What is your problem if it still open - any errors?

Regards,
Koen

Regards,

Koen