update query

[Karen]

I am trying to update a field but get an error message that some of the
records were not updated due to key violations. However, some records are
updated. The field that I want to update is a text field that is not the
primary key. Any ideas?

 

[John Spencer]

Is the field you are trying to update - a foreign key in a relationship
to another table?

Does the field you are trying to update have any validation rule?

Are you attempting to update only one field or several?

Have validation rules for any of the fields changed recently and you are
attempting to update records where the current value in a field doe not
meet the changed requirement?


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================