Table Error

W

Wayne Morgan

Open the table in design mode. Click on each field, one at a time, and look
at the pane at the bottom of the window. One of the options will be Index.
If this is set to Yes (No Duplicates) it means that the index will not allow
duplicate values in that field. If that is what you want, then you need to
fix the data you're trying to add. If that isn't what you want, then change
the index to No or Yes (Duplicates Allowed).
 
L

Lynn Trapp

I'm afraid that we need a ton more information:

1. What version of Access?
2. Are you doing this in a form or directly in the table?
3. Is there a form/subform involved?
4. If 3 is yes, then what are the form/subform linked on?
 
R

Ravi Sandhu

Hi all



When trying to save a record, I am presented with the following error
message:



"The change 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.
"



However, I am not sure what steps to take to resolve this problem... please
advise



Thank you
 
Top