>>>>>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