Strange Problem: Cannot update SQL Server text-fields for some records, but all other fields in a record in a linked table.
Posted on 2003-10-23
i have a very strange problem:
I have a table linked to a SQL Server 7.0 table in my MS Access 97 Application containing 5 text-fields (SQL Server Type, in Access seen as MEMO-fields) and several other fields (in total about 140 fields). Updating any field works fine except for some records. In those records I can only edit the non-text-fields in my application. When I try to edit one of the text-fields I get a error message telling me that another user has edited the record and i have to discard my changes. Deleteing characters from the text-fields works fine.
The strange thing is that this problem only crops up for some records. (1 in a 100 or so) All other records work fine.
Does anyone know what happens here? And how this can be fixed?