autonumbering

[pb21]

I have a table with an autonumber as pk. it has reached 67378 and now has started wanting to add records back from 1 again. The newest record want to start from 19 ( I guess as i attempted to add records from a recordset it used up numbers from 1 to 18 and ditched them).

I obviously could never add records again now. so what should I do, using the tool fix database did nothing.

as the field is an autonumber with long int is there a maximum size due to number of bits used to store?

help would be much appreciated.

I noticed on other tables it did the same went from a number to suddenly adding very large autonumbers out of sequence.



regards

Peter

 

[llkhoutx]

Note that it generally does not matter what the autonumber is, so long as it's unique, it generally merely used as an index.

I use random autonumber, with the Access random number generated re-seeded each session. Otherwise, the test that I've run shoiuld that the same sequence of random numbers is used.

I use random indices for multi-users download and appending certain tables and then uploading appended records. In doing this, I've never had a duplicated number. Plus, I intentionally avoiding using database replication.

This may not anwser you specific question, but might give you my insight to autonumbers and indices.