>I have created a view using the view designer and designated the keyfield to be used for updating the view.
>
>On two occasions I have deleted records from the view and received error 1492: No key columns specified for the update table "name". use the KeyFieldList property of the cursor (error 1492)
>
>Notwithstanding the error the records in question are deleted.
>
>When I checked the view in the designer the keyfield was still marked. If I force the view to be saved again, the error goes away (for a while at least) but has returned on two occasions.
>
>Cleaning and validating the database has no affect.
>
>Has anyone experienced this behavior? Any ideas?
>
>TIA,
>
>Ken
Ken,
How many tables are involved in your view?
May be you have more then one tables and you set some fields from other tables to be updatatble, but not have KeyField(s) defined for that/these table(s).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.