auto-number recycling

[scottshiv]

Auto-number is recycling in our Recipient table. It counted up to 2032 and now it has gone back to 1 and restarted its count. As far as I know nothing has been done to the table to cause it to restart but now we have duplicate auto-numbers all the way up to 845.

Any ideas on what caused this? I have renumbered the table, but I'm worried that it will happen again.

 

[AlexMidd]

Presumably the field is not a unique index (i.e. duplicates allowed).

Have fun! )

Alex Middleton

 

[THWatson]

scottshiv
Is the AutoNumber field indexed with no duplicates?

Is there any process that appends records, by an Append Query, to your table at some point? If so, the append process should not include the AutoNumber field in the records that are appended.

Tom