Nick, Try putting a specific named lock around your CFFILE operation. I suspect CF has the file still locked.
-Mark -----Original Message----- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 11:36 AM To: CF-Talk Subject: Re: Reading CSV files with the ODBC text driver Mark > Is the file unlocked and does the driver have permissions to access it? It should be unlocked - it's been uploaded by a CFFILE just before the CFQUERY is run. As regards whether the driver has permissions to access it - CF certainly has, but I don't know about the driver itself, if that's a separate issue - how do I tell? Thanks Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

