Error Message

[SITCFanTN]

I have a database that was created 5 years ago and has worked like a charm
all this time. There have been no changes made to the programing, however
now an error message displays when I try to add a new record. The error
message states "The changes you requested to the table were not successful
because they would create duplicate values in the index, prmary key or
relationship. Change the data in the field of fields that contain duplicate
date, remove the index, or redefine the index to permit duplicate entries and
try again" The issue is there have been no changes to the database and the
record being added are not a duplicate record. Could this mean the database
is corrupt? Your help is much appreciated.

 

[Gina Whipp]

SITCFanTN,

Sounds like you are using a Autonumber field as as Primary Key and it has
goten corrupted. You can confirm this by looking directly at the table and
trying to add a new record and see if it tries to an anlready used number.
Have a look at... http://allenbrowne.com/ser-40.html

--
Gina Whipp

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

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