Jon,

I doubt that you'll find that information inside of the O/S as it is managed by VFP itself. You might go over to www.hallogram.com and see if they have any API libraries that could help.

Other than that you'll need to roll your own. It's not too difficult - all you need is a table that contains some basic information like:

User's Name
Table Name
Record Number
Date & Time of lock

etc... With this you can build your own locking semaphore table and then 'wrap' your RLOCKS with it.

Best,

DD

>Doug,
>
>I've tried the usual Server manager - this shows open files but not FLOCK and RLOCKS.... Are you aware of any other tools (Perfomance Monitor/Resource Kit..)?
>
>Cheers
>
>Jon Nelson
>
>>>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