>I have a problem when I try to update a remote view containing general field I use to store a picture of each employee. When the view is updated, the following error occurs "General fields cannot be used in the WHERE condition of an update statement. Change the Wheretype property of the view". I removed the update tick of the general field in the view designer and still the same thing happens (and anyway, the picture may need updating).
>
>Any help appreciated.
>
>Peter

Select 'Key Fields Only' in 'SQL WHERE clause includes' on Update Criteria Page.