After entering 83 records unable to go on to next record

D

Dee

someone else set all the fields up for me as I'm not familiar with Access and
I was just putting in the data, and got through to no. 84 and entered the
data - when I tried to go to the next one a message came up saying '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'. I haven't
a clue - all I know is that this record was no different to the other 83!
Help please
 
R

Roger Carlson

This error means that you've entered the same value in one of the fields
that is the same as in one of the previous 83 records. A Unique Index or
Primary Key (the two things the message box is referring to) won't allow you
to do that.

If you go into the Design View of the table, there will be a little key
symbol on the field(s) that make up the primary key. Check that field in
your data to see if the value of that field in record 84 matches any of the
other records. If it doesn't, check the properties of each of the other
fields (again in Design View). If any of the them say *Indexed: Yes, no
duplicates*, then check that field as well for duplicate values.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
L

Lance

Your table has a primary key set up and it doesn't allow you to enter the
same value in that field more than once. The record you are trying to add
has a value in the key field which already exists in your table. You will
need to give your new record a unique value for that field to add it, you
also might want to verify that it should be added.
 
D

Dale Fye

To go one step further, you may also have a multi-field index. The best way
to check your indexes is to open your table in design view, then click the
"Indexes" item on the toolbar (it has a lightning bolt on the right side of
the image). This will pull up a list of the indexes on your table. If you
have a multi-column index you will see a Index name in the left colum, and
then multiple field names in the second column. If you click on the Index
Name, you will see the Index properties, which indicate wheter the index is
Unique.

HTH
Dale
 
T

Tony Toews [MVP]

Lance said:
Your table has a primary key set up and it doesn't allow you to enter the
same value in that field more than once. The record you are trying to add
has a value in the key field which already exists in your table. You will
need to give your new record a unique value for that field to add it, you
also might want to verify that it should be added.

Actually it can be an index that is setup. Not just a primary key.
Furthermore, as Dale points out, it can cover multiple fields.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

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

Top