Autonumber field reset now has duplicates

[jkafer]

I have a database application that I have been running for 2 years now and all of a sudden the autonumber field reset itself and now has dublicates in it.

Does anyone know why/how this happens?

I have compacted/repaired the datafile, with no difference.
I have copied the table, and the problem followed.

Jeni

 

[Golom]

Certainly sounds like a corruption issue dispite compact/repair not fixing it.

If it's possible (i.e. no relational dependencies on that field), try deleting the autonumber field and then re-creating it.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]