You can close the table when you are done with it with:
USE IN Sub
Or you can use this code to check if the table is already open:
IF USED ("Sub")
SELECT Sub
ELSE
USE Sub IN 0
ENDIF
HTH
>I use the following, to use the table in my program:
>sub is the table name:
>********
>USE sub IN 0
>**********
>
>After i use the above code, first time it is ok and when next time when i try to use the same i get the message "File is in USE"
>
>Can you please tell me how i can release the file after in use the file in my program, so next time when i go, the program should be able to use.