I have an Access 2000 table with a MemberID field as the primary key.
Data Type = autonumber
Field Size = long interger
New Values = increment
Indexed = Yes (No Duplicates)
For the past year, the MemberID field has worked correctly creating a unique MemberID number for each new record.
Recently, when I try to insert a new record, I get a value in the MemberID field that is a duplicate of an existing record.
Any ideas why this might be happening and how to fix it?
Thanks, John
Data Type = autonumber
Field Size = long interger
New Values = increment
Indexed = Yes (No Duplicates)
For the past year, the MemberID field has worked correctly creating a unique MemberID number for each new record.
Recently, when I try to insert a new record, I get a value in the MemberID field that is a duplicate of an existing record.
Any ideas why this might be happening and how to fix it?
Thanks, John