Find if table is open by another user
Find if table is open by another user
(OP)
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
I wan to Find if a certain table is open by another user without trying to open or access that table.
Best Regards
RE: Find if table is open by another user
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.
CODE
IF ERRORCODE() = 05 ! Access Denied
!open by another user
ELSIF ERRORCODE()
!some other error
ELSE
!open with exclusive access
END
CLOSE(<Table>)
Regards