G
Guest
I have an Access 2003 MDE FE/BE solution that is getting an error 3188 on a
specific record. The error only occurs when the user selects the entry and
clicks the "Update" button (the entry is added without any problem, it is
only when they want to update/add aditional text to the memo field). The
code below is what is used to do the update:
dbIASSecure.Execute "UPDATE [Strength]" & _
"SET StrengthFB= '" & Replace(Forms!responses!txtStrength, "'", "''") &
"', KeyStrength= " & Forms!responses!chkKeyStrength & ", StrengthCC= " &
Forms!responses!chkStrengthCC & ", " & _
"STEvalFactors= """ & tmpSTEvalFactors & """, collabid= """ &
tmpCollabid & """, STKBF= """ & Forms!responses!txtstkbf & """ " & _
"WHERE Id= " & Forms!responses!lstStrength.Column(2) & " AND
Organization= """ & Forms!responses!lstStrength.Column(1) & """ AND Qnum= " &
Forms!responses!lstStrength.Column(0) & " WITH OWNERACCESS OPTION"
The field that is being changed is a memo field and they have no problems
with updating other records for this field - it only happens on a specific
record.
I have the Open Databases with record-level locking checked and Default
record locking set to No Locks on the options tab.
Thanks in advance for any help or suggestions.
Jerry
specific record. The error only occurs when the user selects the entry and
clicks the "Update" button (the entry is added without any problem, it is
only when they want to update/add aditional text to the memo field). The
code below is what is used to do the update:
dbIASSecure.Execute "UPDATE [Strength]" & _
"SET StrengthFB= '" & Replace(Forms!responses!txtStrength, "'", "''") &
"', KeyStrength= " & Forms!responses!chkKeyStrength & ", StrengthCC= " &
Forms!responses!chkStrengthCC & ", " & _
"STEvalFactors= """ & tmpSTEvalFactors & """, collabid= """ &
tmpCollabid & """, STKBF= """ & Forms!responses!txtstkbf & """ " & _
"WHERE Id= " & Forms!responses!lstStrength.Column(2) & " AND
Organization= """ & Forms!responses!lstStrength.Column(1) & """ AND Qnum= " &
Forms!responses!lstStrength.Column(0) & " WITH OWNERACCESS OPTION"
The field that is being changed is a memo field and they have no problems
with updating other records for this field - it only happens on a specific
record.
I have the Open Databases with record-level locking checked and Default
record locking set to No Locks on the options tab.
Thanks in advance for any help or suggestions.
Jerry