>When working in forms, I use:
> If Not Used('myfile')
> USE path + myfile
> ENDIF
>
>Even if the file IS in use, Fox 7 still tries to execute the USE. Result: error.
>
>Anyone know why?
>
>Thanks, Randy
USED() (I think, because this is not in HELP file) checks if the file is USED() in current data session. If you are used that file in some other DS and you have EXCLUSIVE use of that file you will get the error. Also if you are used the file somewhere else but with different ALIAS and again this file is EXCLUSIVE use, you also will get the error.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.