>Is your view updateable ?
>Have u clicked on Send SQL updates in the view designer ?
>I did not understand what u are trying to do exactly.
>
>Reply me so I can help u.

Yes to all of the above- in fact it's all SQL pass-through.

The problem seems to be that most of the records are updated, but one or more are not. This in turn generates an error.

Now this could be because of a primary key violation or some such thing, but I check for that or any error for that matter, and the error routine does not fire.