Duplicate value error although there is no duplicate value

[Mike]

I have a table where I have assigned a primary key and index for a
specific number.
The db worked for approx. 1/2 year and today I get a duplicate value
error when I try to create a specific number in the table (in this
case, the number is T-1379-1).
The table prohibits duplicate values and the number T-1380-1 can be
inserted to the table without a problem. I started at (or the last
good number was) T-1378-1.
I've checked the complete table, but couldn't find number T-1379-1.

Can anyone help?

 

[Mike]

I have a table where I have assigned a primary key and index for a
specific number.
The db worked for approx. 1/2 year and today I get a duplicate value
error when I try to create a specific number in the table (in this
case, the number is T-1379-1).
The table prohibits duplicate values and the number T-1380-1 can be
inserted to the table without a problem. I started at (or the last
good number was) T-1378-1.
I've checked the complete table, but couldn't find number T-1379-1.

Can anyone help?

Just checked the table again. Several forms are pulling data from the
same table, and if the forms are used, the data is consistent.
However, my Boss was modifying the table directly but didn't change
all values of the table, so that the data was inconsistent which
caused the db to screw up.

Sorry for the false alarm

 

[John W. Vinson]

However, my Boss was modifying the table directly but didn't change
all values of the table, so that the data was inconsistent which
caused the db to screw up.

Don'tcha wish you could set database security to keep The Boss from getting
under the hood.... and give him a just subtly wrong password to the
administrative screens? "Can't imagine why it's not working for you..."

John W. Vinson [MVP]