>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