Unable to append table through query.

[Guest]

I have a form which uses update query.
The problem is intermminent, what happens is get the below mentioned error
message when I try to run Update query, any ideas?

The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again.

 

[tina]

you need to look at the table in design view, to see which field or fields
are the primary key, and/or have a unique index set on them. then review the
data you're trying to append or update - are there any duplicate values,
either within the data you're entering in that field or fields, or between
the new data and the data already in the table?

that will tell you where the problem is, but it won't "fix" it. there's no
way around a unique index in a table, the data in each record *must be*
unique in that field or fields. you'll have to decide whether or not you
need the field(s) to have a unique index or not. if you do the above
research on your table and data, and can't decide how to proceed from there,
we might be able to give some advice; you'll need to explain what field(s)
are causing the problem, and what data they contain, to start with.

btw, "appending" and "updating" are different actions. "appending" refers to
adding one or more *new* records to a table. "updating" refers to changing
data in one or more fields in one or more *existing* records in a table.

hth

I have a form which uses update query.
The problem is intermminent, what happens is get the below mentioned error
message when I try to run Update query, any ideas?

The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try

again.