We have a fox 2.o multi user application in a 5 user novell 5.0 network.When i execute a select statement with 20 fields using macro substituion for tables, i get the message "Temp file does not exist" when i run the sql for the second time using a different table. Once i log out and login the sql executes perfectly. whether i have to set the temp and sort directories in the local drive. Kindly help


Venkat