>Hi,
>
>I have a query which access 13 tables and when I execute the query I get the progress bar stating running query and finally pops up an error message "can't create temp work files".
>
>Why would I get this error when I have sufficient disk space.
>
>Thanx
>Gnana.
Are you sure you have the space? By the time you get the message and check your current disk space, some of the temp files may be deleted because the process has stopped.
You may want to break your query up into smaller steps.
HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown