Saech key not found error

Access memo fields

[aspdaddy]

>Search key not found error

This error is caused when memos fields have around 2000 characters in, and the records are updated, does anyone know of a fix.

thanks.

[TheDave]

Are you updating through a query or recordset? Try the other way ;)

cm.CommandText = "UPDATE [blah] SET [blah]=blah WHERE.."
cm.Execute

or

rs.Open "SELECT [blah] FROM [blah] WHERE...", cn, 3, 3
rs("blah") = blah
rs.Update

Failing that, perhaps instead of updating the data, you read it, delete it, then re-insert it?