>>>Using FAQ #7896, by Ramon F. Jaquez, I can now find out which user has opened a certain file. Now, I would like to know which user have it open exclusive and which shared - but I don't see such an option in this download. Is it possible to get this information?
>>
>>If you can't open the file yourself (issue some command with error trap) then it's exclusive, if you can then it's shared.
>
>Sure. But: In my system, there is apparently some rogue process that keeps the file open exclusively, and I don't know which process it is, or which user is using it. So the question is not, did someone use it exclusively, but rather, who. I hope this will help me track down the error.
>
>FAQ #7896 tells me who is using some file, but not, whether it is exclusive.
If the file is opened EXCLUSIVE there is only ONE user who is opened it :-)
So you could try:
old_error = ON([ERROR])
fl_error = .f.
ON ERROR fl_error = .t.
USE (lcFile) SHARED
IF fl_error
ENDIF
USE IN SELECT(lcFile)
ON ERROR &old_error
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.