duplicates error after 2 years- why?

[dab1477]

Question: Why would I get an error duplicate message after running this
database for 2+ years? At this point, I cannot add additional data without
receiving an error message.
I have recieved the followng error message from a manufacturing database I
created, and has been in use since 2008..."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 entires."

Issue: Operator uses a form to input Date, Shift, Machine #, hourly output,
and total downtime for 13 types of downtime. As of 1/20/2009, the operator
receives above error message.
There can be duplicate information in the date and shift fields, but date,
shift, and machine cannot be duplicated. I have verifed that there is not a
duplicate of these 3 as a group.

I have tried to perform "Detect and Repair" on copy of database. When I do
this, I lose all records after 6/29/2009. I can successfully enter 1/20/2010
data, but cannot import missing data (I exported 6.30/2009 - 1/19/2010 data
from original database). I have backup versions of database dating to
4/28/2009. I am unable to import missing data from original database into
this backup as a means of getting a workable copy.

Thanks for your help and direction.

 

[Gina Whipp]

dab1477,

The bad news sounds like your Primary Key is corrupted... Searching that
filed for duplicates will produce no duplicates as it won't duplicate you
will just get the message below.

The good news is ther *MIGHT* be a way to fix it, see...
http://allenbrowne.com/ser-40.html

Let us know if the above works for you! (Note, at the bottom of that pages
shows possible reasons.) I will also add, daily back-ups always a good
thing!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Question: Why would I get an error duplicate message after running this
database for 2+ years? At this point, I cannot add additional data without
receiving an error message.
I have recieved the followng error message from a manufacturing database I
created, and has been in use since 2008..."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 entires."

Issue: Operator uses a form to input Date, Shift, Machine #, hourly output,
and total downtime for 13 types of downtime. As of 1/20/2009, the operator
receives above error message.
There can be duplicate information in the date and shift fields, but date,
shift, and machine cannot be duplicated. I have verifed that there is not a
duplicate of these 3 as a group.

I have tried to perform "Detect and Repair" on copy of database. When I do
this, I lose all records after 6/29/2009. I can successfully enter 1/20/2010
data, but cannot import missing data (I exported 6.30/2009 - 1/19/2010 data
from original database). I have backup versions of database dating to
4/28/2009. I am unable to import missing data from original database into
this backup as a means of getting a workable copy.

Thanks for your help and direction.

 

[willie]

Question: Why would I get an error duplicate message after running this
database for 2+ years? At this point, I cannot add additional data without
receiving an error message.
I have recieved the followng error message from a manufacturing database I
created, and has been in use since 2008..."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 entires."

Issue: Operator uses a form to input Date, Shift, Machine #, hourly
output,
and total downtime for 13 types of downtime. As of 1/20/2009, the operator
receives above error message.
There can be duplicate information in the date and shift fields, but date,
shift, and machine cannot be duplicated. I have verifed that there is not
a
duplicate of these 3 as a group.

I have tried to perform "Detect and Repair" on copy of database. When I do
this, I lose all records after 6/29/2009. I can successfully enter
1/20/2010
data, but cannot import missing data (I exported 6.30/2009 - 1/19/2010
data
from original database). I have backup versions of database dating to
4/28/2009. I am unable to import missing data from original database into
this backup as a means of getting a workable copy.

Thanks for your help and direction.

 

[KARL DEWEY]

A couple of thoughts.

You might copy the table structure, add the data that it says is duplicate
and run a match query. That will check your multiple field index one way.

Run a totals query on the three fields and set criteria >1. Same on the
primary key.

 

[dab1477]

Thanks Gina,
I successfully added the code noted in the Knowledge base LINK that you
provided. I'm assuming that this code will prevent duplication from
recurring. As of today, I was successful in entering multiple records into
the database after the fix was instituted. I appreciate the direction.

 

[Gina Whipp]

dab1477,

Now let's not get ahead of ourselves... it will not *prevent duplication*.
The code provided by Allen (not the Knowledge Base) will help to fix it
should it happen again. You will need to study the causes and be sure none
of those apply to you and keep your finger crossed for it never to happen
again!

Glad to help!
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks Gina,
I successfully added the code noted in the Knowledge base LINK that you
provided. I'm assuming that this code will prevent duplication from
recurring. As of today, I was successful in entering multiple records into
the database after the fix was instituted. I appreciate the direction.