I need to be able to lock a table for exclusive use AND report to other
users attempting to access, for any reason, the same table. For example,
Betty opens the table and is using it. Tammy tries to use the same table
and is locked out with a message "Table in use by Betty." Whereby Tammy can
cancel and resume work.

I would appreciate any ideas.

Thanks,
--
Bill Skelton

Bill,

you might want to use "LOCK TABLE <yourTable> IN EXCLUSIVE MODE". If an
error occurs call SA_LOCKS tp check if another user already locked the
table.

LOCK TABLE will work with SQLA 7 and higher.

Cheers
Reimer

Bill Skelton wrote: