Also, have a butchers at SysInternals tools from Microsoft, things like Process Explorer will do the trick.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Gaulin, Mark To: CF-Talk Sent: Mon Feb 05 22:46:25 2007 Subject: RE: How to Check for Open Files.... Not that this is likely to help you, but there is a Windows resource kit utility called "oh" (for Open Handles) that will show all open files and the processes that have them open. This is a debugging tool only (it's slow), but you might be interested in knowing if ftp, iis, or cf actually has the file open. I have been surprised in the past when I assumed that I knew who had a file open. Also, can you try renaming the file from code? Maybe that will be enough to let the upload work the second time. I'm reading your post again, and if the XLS file is being used as a datasource then you ought to expect that it is open... CF is querying it! Maybe you need to release all your existing "db" connections, like on the datasources admin screen... I think there was a way to do that from code. Anyway, good luck. Mark -----Original Message----- From: T Burke [mailto:[EMAIL PROTECTED] Sent: Monday, February 05, 2007 3:15 PM To: CF-Talk Subject: How to Check for Open Files.... I have a client who uploads an excel spreadsheet daily (FTP), which is her datasource to her CFMX website. Unfortunately, the file gets uploaded then locks up so that she cannot upload the next day, nor can the file be deleted w/o contacting technical support to delete (Windows servers). I suspect the client is attempting to upload while she has the spreadsheet OPEN, which is turns hozes up the files permissions and locks. Is there a way to 1) Check to see if the file is open or in use or 2) require the file to be closed before she uploads. Can this be done in CF? Suggestions, comments, ideas... All are most welcome. I am considering either writing a script that performs the uploads for her or writing a script that will suck her excel spreadsheet into a MySQL database (ugh). If we can keep it simple though, and just get a good, consistent upload of the xls file, that would be ideal. Tx, DG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:268752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
