I'm trying to resolve a deadlock situation on a multi-user VFP database using free tables.

Is anyone aware of any tools (running on an NT Server) that show which user (at a connected workstation) has a record/file lock on a table? Ideally I would like to be able to see that user X has table name YYY open at workstation ZZZ with a record number NNNN locked...


I've spent some time digging around trying to find info on this and have looked at Win API NetFileEnum - but this seems to be a dead end...

Any information on exactly how record locks are applied at a low level would be appreciated (is this to the actual DBF file or is this done using some other operating system mechanism)???

TIA

Jon Nelson