Index, Primary Key Issue

[Tee See]

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.

 

[Jeff Boyce]

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

 

[Pat Hartman\(MVP\)]

If your pk is an autonumber, it may have "broken" and be generating
duplicate numbers.

 

[Tee See]

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