>>>>>>>>>>>I was trying to rebuild index tables of VFP 9 application today (at customer site) and ran into the following problem. One of the .cdx files was locked and no matter what I and the IT person tried we could not delete this file. He looked at the server at Shared Folder file and this file was not showing. No other application had none of the .DBF or FPT files open. But every time I tried to delete this .CDX (in command prompt or from the application) I was getting "used by another process" message. Is there a way to find out what process has this .CDX file locked?
>>>>>>>>>>>
>>>>>>>>>>>TIA.
>>>>>>>>>>
>>>>>>>>>>If you have access to the server you can try this: (one of my favorite tools)
>>>>>>>>>>http://download.cnet.com/Unlocker/3000-2248_4-10493998.html
>>>>>>>>>
>>>>>>>>>Does that work as advertised?
>>>>>>>>
>>>>>>>>Yep - I use it all the time.
>>>>>>>
>>>>>>>I'm always a little leery about using forcing tools like that, in case of data corruption. It would be really nice if it could show which computer holds a lock, so that one could be rebooted - do you know if it can do that?
>>>>>>
>>>>>>There is a VFP program that does that called WhoHasFile.prg - it used to be on vfug.org but I can't seem to get to that site for some reason. I know I have a copy of it at home though....
>>>>>>http://fox.wikis.com/wc.dll?Wiki~WhoHasFileLock
>>>>>
>>>>>I believe that WhoHasFile.prg will work if a file is opened by an application. But in my case the file in question is a .CDX file. And the .DBF and/or .FPT file for this .CDX can be deleted without a problem. Thus I can't think of an application that will open a .CDX file. I think in my case it must be AV (as Naomi suggested) or some service.
>>>>
>>>>I think the WhoHasFile.prg would show that the AV app has a hold of the app if that's the case. Do they use that server 24/7 or is that a time that it could be safely rebooted?
>>>
>>>Accordning to the IT guy the server is used 24/7 and rebooting has to be scheduled carefully.
>>
>>Hopefully their IT guy will use the little unlocker tool then. FYI that handy little tool will also tell you which process has the file locked.
>
>Do you know if the Unlocker has to be installed right on the server? And when it is installed, is it like a Windows application that has to be registered in the registry?

It would have to be installed on the server - and I don't know all what it does when installing - might check here http://www.emptyloop.com/unlocker/
The app is very very tiny so it's not intrusive to run at all.