Find if table is open by another user

[newtoclarion]

Hello everybody

I wan to Find if a certain table is open by another user without trying to open or access that table.

Best Regards

 

[ShankarJ]

Hi!

Without trying to open or access the table, it is difficult to find if it is use. But the below code will work to find out if some other user has the file already open.

OPEN(<Table>, 12H)
IF ERRORCODE() = 05 ! Access Denied
   !open by another user
ELSIF ERRORCODE()
   !some other error
ELSE
   !open with exclusive access
END

CLOSE(<Table>)

Regards