I think we are saying the same thing.

In any case, I removed the view form the project and re-created it from scratch, and now can add & delete records fine.

Thanks!

June

>No, I'm sorry. I meant delete it and re-create it. If it's a complex view, view the SQL code and copy and paste it into a program file and then re-create it using the create view command.
>
>>Thanks.
>>
>>By "drop and re-add", you mean remove the view from the project, and then re-create it?
>>
>>June
>>
>>>June,
>>>
>>>I get this often. And the way I always solve it, is by dropping the view and re-adding it. I know this doesn't answer 'why' it is happening, but as I have mentioned before to you, there are times when finding the answers why is not so important.
>>>
>>>>Thanks for the suggestion.
>>>>
>>>>I did have some of table 2's fields interspersed with those of table 1 in the view, and corrected that, but I'm still getting the 1547.
>>>>
>>>>June
>>>>
>>>>>Hi,
>>>>>Make sure your view's updatable fields is not seperated by any non-updateable field. For example, table1 is the source you want to update:
>>>>>
>>>>>**This should work fine
>>>>>View : MyView
>>>>>Selected Field List : MyTable1.Field1, MyTable1.Field2, MyTable2.Field1
>>>>>
>>>>>**This may cause error 1547
>>>>>View : MyView
>>>>>Selected Field List : MyTable1.Field1, MyTable2.Field1, MyTable1.Field2
>>>>>
>>>>>HTH