I’m experiencing the following Write Conflict Error when editing a “Memo” field on an MS Access subform:
“This record has been changed by another user since you started editing it. If you save the record you will overwrite the changes the other user has made. … “
Options: Copy to Clipboard or Drop Changes
Environment: Access 2003, SQL Server 2005, Windows 7 Pro
I have a main form with one subform.
The main form is not bound to any table or query. All of its controls are populated by its On Open Event handler. One of these controls (a textbox) contains the subform’s Linked Master Field.
The subform is bound to an SQL Select statement whose underlying table is an SQL Server table linked via ODBC. The table contains some fields with a character datatype.that exceeds 255 characters (e.g., ntext, nvarchar(256), etc). When the table design is viewed in Access these fields appear as Memo fields.
Whenever I edit any one of these fields on the subform, and then move to a different record, I get the Write Conflict error; and there are no other users.
Changing the datatype to nvarchar(255) solves the problem, but that is too limiting for my client.
Is there a solution to this problem?