If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Index, Primary Key Issue
I receive the message "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 .......etc." The primary key is the only field that is "indexed with NO dulicates". One other field is indexed but duplicates are okay. There is no other record matching what I am trying to input so why am I receiving this error message? I have successfully addd data (a new record) to this table in the past. Why now specifically? Appreciate any help. |
#2
|
|||
|
|||
Index, Primary Key Issue
When do you receive the message? Are you trying to run an append query?
Are you trying to modify the table structure? Access seems to be saying that you DO have a duplicate. Have you tried looking up what it is you are trying to add? (if that's what you are doing). More specific description may lead to more specific suggestions. Regards Jeff Boyce Microsoft Office/Access MVP "Tee See" wrote in message .. . I receive the message "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 .......etc." The primary key is the only field that is "indexed with NO dulicates". One other field is indexed but duplicates are okay. There is no other record matching what I am trying to input so why am I receiving this error message? I have successfully addd data (a new record) to this table in the past. Why now specifically? Appreciate any help. |
#3
|
|||
|
|||
Index, Primary Key Issue
If your pk is an autonumber, it may have "broken" and be generating
duplicate numbers. "Tee See" wrote in message .. . I receive the message "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 .......etc." The primary key is the only field that is "indexed with NO dulicates". One other field is indexed but duplicates are okay. There is no other record matching what I am trying to input so why am I receiving this error message? I have successfully addd data (a new record) to this table in the past. Why now specifically? Appreciate any help. |
#4
|
|||
|
|||
Index, Primary Key Issue
Thanks for your responses. After reading them I looked a little closer and
found the problem. The problem was with MYSELF rather that access. Again thanks "Tee See" wrote in message .. . I receive the message "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 .......etc." The primary key is the only field that is "indexed with NO dulicates". One other field is indexed but duplicates are okay. There is no other record matching what I am trying to input so why am I receiving this error message? I have successfully addd data (a new record) to this table in the past. Why now specifically? Appreciate any help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autonumber using alpanumerics | Katharine Jansen | Database Design | 18 | August 19th, 2005 12:54 PM |
Querying tables with 2 primary keys and index | Crusader | Running & Setting Up Queries | 0 | July 8th, 2005 02:50 PM |
Two primary key fields/Unique Index problems | Rebecca | Database Design | 0 | March 31st, 2005 12:31 AM |
Difference between primary key and index | Amir | Database Design | 3 | January 30th, 2005 04:05 AM |
Primary Key/Read only issue | Steve S | Database Design | 1 | December 23rd, 2004 02:22 PM |