Find if table is open by another user

newtoclarion · Apr 15, 2012

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 · Apr 15, 2012

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.

Code:

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Find if table is open by another user

newtoclarion

Programmer

ShankarJ

Programmer

Similar threads

Part and Inventory Search

Sponsor