error: duplicate values

L

LI

What does the error message Duplicate values in the index
and primary key or the relationship mean? My daughter was
trying to add another record to a table and Access won't
let her add more than 30. Thanks, Linda
 
J

James Brown

Hi,

If the table has a primary key or an index (no duplicates) set on a field,
then you cannot enter the same data into that field in more than one record.
Check your table design and look at the properties on each field - you
should find that one has the "Index: Yes (No Duplicates)" option set, in
which case two records in the table cannot have the same data for this
field.

There are two solutions to this: either set the Index to "Yes (Duplicates
OK" in the table design (but bear in mind that the person who designed the
database probably had a good reason for this being setup like that), or
enter different data into the field.

Cheers,

Jamie.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Error message regarding duplicate values 1
Duplicate values in the index, primary key, or relationship messag 2
import data from excel 2003 to a table in an existing database 2
Duplicate values 4
duplicate value error message - new issue 1
Copy or Duplicate Record Woes 3
Duplicate Values in the index, primary key or relationship 4

Top