I am executing a fairly big sql query followed by a few smaller queries and then spitting the result to a comma-delimited (.csv) file. I tweaked the query yesterday (as per the customer) and the query runs longer and I now get an error processing cffile. It says there is a sharing violation. I go ahead and open the incomplete csv file and each time there is a different number of records that make it to this file (sometimes 673 records, sometimes 663, sometimes 670, etc.., and a couple of times it has completly ran - all the way thru with no errors!). and I know no one else is using this file. I delete the file and run my program again and I still get the same problem. any suggestions? any help would greatly be appreciative.