Whenever I tried to update ANY MEMO FIELD in ONE SPECIFIC record in an SQL Server database backend, a message would always appear saying someone else is editing the same record, etc. The changes could not be saved. But in fact nobody was editing the same record.
This happened only to one record but not others, and happened only to the memo fields in that record. It should have nothing to do with the data I tried to enter because when I tried to enter the same data into other records (the memo fields), it saved ok.
The front-end is Access 2003. It has got to do with the Backend, not the Access front-end because this happened also when I directly edited the backend tables.
Does anybody know what caused this problem ? Thank you in advance.