This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.

To correct this follow the below steps.

Open SQL Management Studio, open the Sage200Configuration database and view the tblLock table. You will find one of 2 possible scenarios:

1 – the "SessionIdentifier" column is populated:

Do not amend the LockID or LockType columns. You only need to remove the entry from the SessionIdentifier column.

2 - there is only a "NULL" row:

Please copy and run the script below against their configuration database.

insert into tbllock
(SessionIdentifier, LockType, UserName)
VALUES ('',0,'')

You should then end up with a table that looks similar to the one below.

You will now be able to edit the menu editor in Sage 200 as expected.