I'm using SEOM 5.612 with SQL Server 2005. Sometimes I'm trying to make some changes on the Inventory (change QOH, description...) and get an error 3157: ODBC - update on a linked table 'Inventory' failed. I noticed that I can solve that problem by asking the other users of StoneEdge to close their Inventory form (if they have it open)
I'm wondering why I get this error message. It seems like there is a 'lock' on the Inventory table from the other users. Although using SQL Server I would not expect those kind of issues.