>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
Jim,
Well, you can look at the System Tools stuff built in and find out who has what resources open but programatically I don't really know off hand.
Check out Communications Horizons. Neil Weicher usually has something that works. Bright guy.
Best,
DD
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.