Hi All,

I am using dDBASE 5.0 for DOS.

I have a file locked and I am trying to get the information on who locked it. So far, I have tried using LKSYS() (already CONVERTed the tables) and it only works if I issue the command with the same user that has the file locked. Given that information, I could check a database for lock information, then lock the file and have the user report their information DBF(), ID(), TIME() and DATE() to a database file to be read by other users.

Is there a better way to get the lock information?

Thanks

---
"One source to query, one source to answer and one source to bind them." Aaron Sharp

dBase can not tell you who has the file locked,  The operatining system has that information.  The network Administrator can help you with it.

Depending on the operating system,  Yo9u can make calls from dBase to the OS and get the info.  

David W. Grewe Dave

The problem for decades has been that you can write programs to post to a logging table when a table is opened and later closed.  Unfortunately, life happens and there will always be exceptions now and again, such as...

• Someone running a dBase developer's version will manually open a table - and it is not logged as in use.
• Someone will crash their computer, or turn it off, or have a power glitch while the tables were open - and it is still logged as in use when it is not.  (On rare occasions a computer crash can leave server still thinking a file is open.  In that case, logging back on to the server and logging off properly usually clears it.)