I have set up my tables to have auto-generated unique IDs for each record.
The ID field is set to "identity" and has a unique constraint on it making
it a key field.
I create new records from an ACCESS 2000 front end. It was working fine
until yesterday when an operator shown me an error message to the effect ;
"tblxxx , attempt to insert duplicate key (or identity) values)..... error
The record would not be inserted. I went into SQL server (6.5) enterprise
manager and looked at the table indexes. I clicked "rebuild" and under
distribution "update". After this new records would be inserted.
I do not know why the problem occurs in the first place. I also do not know
why I was able to clear the problem by manually rebuilding the indexes. Do I
need to have a procedure to automatically check the indexes?
Any help would be appreciated. Thanks.