The changes were not successfully saved because of duplicate data?

  • Thread starter Thread starter smith
  • Start date Start date
S

smith

When I work with Access, the message often display. What is the problem?
 
The message indicates that your table has an index that is either the
Primary Key or has its Unique Values property set to Yes. As a result,
duplicate values are not permitted in indexed field(s).

For example, say you have a table of clients. In table design view, you
selected the Surname field, and in the lower pane, set the Indexed property
to:
Yes (No Duplicates.)
You entered some records, including Mr Fred Jones.
Later, when you try to enter Mrs Martha Jones, you will get the error.
 

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

Back
Top