Auto Number Jump

[Mickey12]

Hi for some reason the auto number in a table jumped from 282 to 44058.
There are no records between these numbers.
Any way to reset?
Thanks

[RoryOF]

Are there entries subsequent to 44058?

[Mickey12]

no entries after 44058

[RoryOF]

Then, that might be incidental corruption of the data, or imminent disk failure.

282 is 0x001A in hex, 44058 is 0XAC1A - so only one byte needs to have changed.

I cannot make any easy suggestion for a method of correction; if it were me, and I was satisfied that it was a one off occurrence, I would edit the file or the hard disk with a hex editor, but am loath to suggest that to someone unskilled in such low level tasks.

[Mickey12]

Ok. Thanks for that. I have backed up. (off machine) Will just continue as is.

[Villeroy]

This should never bother anybody. The database engine decides which number is the next one. If you delete some records, say 1000 to 1999, the next record will be 2000 anyway. This is a good and efficient way of handling things. The auto-IDs should be completely meaningless to the user and administrator. It should be seen as a completely abstract record identifier.