How to avoid: "The xyz table cannot be locked or change

cnaervig

How do you avoid this errormessage:

"The xyz table cannot be locked or changed because it is already locked by the user with User ID xyz.
Wait until the user is finished and then try again."

Why don't Navision just wait for the table to unlock, at it usually does?
The program in question does not use LACKTABLE(FALSE).

Thanks
Carsten Nærvig Sørensen
Capto a/s

Marije_Brummel

I do not think it can be changed, at least not easily.

MAybe this post will help

http://www.mibuso.com/forum/viewtopic.p ... ady+locked

cnaervig

Thanks.
I am afraid you are right.
I had already read the thred you are pointing at. It tells som basic measures to take to reduce the negative conesequences of table locking.
But it sounds like this error is something you must learn to live with in in busy multiuser systems, after you have optimized programs and hardware.
I think it is something that happens when Navisions optimistic table locking fails, because of too many simultaneous writes.