synching record number and autonumber

[Gena R.]

My record numbers and autnumber were initialy in synch.
When existing records get accidentally deleted the
database and the autonumber get out of synch. Is there a
way to synch these back in.

 

[Van T. Dinh]

No.

Note that the only purpose of AutoNumber Field is to provide *uniqueness* to
each Record in the Table. Hence, the actual value allocated to each Record
shouldn't matter.

You should not attach any meaning to the AutoNumber Field as they can become
random or even negative. In fact, users shouldn't even see the values of
AutoNumber Field. If you need to assign some meaning to the Field, don't
use AutoNumber for this Field.

 

[James Goodman]

No, this is not the purpose of Autonumber fields.

If your Autonumber field is on 301 & you delete RecordNo 250, this number
will not be reused.

Likewise, if you delete RecordNo 301 & then insert another record, the new
number generated will be 302. However, if you compact the DB between the
delete & the insert it will reset the counter, so the next insert will again
start with 301...