It's really bad idea to use specific work areas. Let VFP use any free one.
The USED() function can tell if alias is in use.
>Every time I create a table as a result of an sql query it uses the work area of one of my open files - is there any way I can I can make it open in a specific work area?
>
>Another question - how do I check to see if a table is open?
>
--sb--