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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> When I work with Access, the message often display. What is the problem?
Similar Threads
