>Does your logic lock/update/unlock the 'key' table *before* it does the INSERT INTO?, or do you do the INSERT INTO while the 'key table' is still locked?
The key table, which is known here as THREAD, is never locked. The reference to the locked table was to TABLE.DBF, which is used to keep all the actual key.