Thanks everyone,

Since it has taken about a year and one-half to total 5,300 records and the table is narrow we've added the unique index. This should prevent the problem...