You could use an APPEND Query to insert a dummy Record with the value 100
for the AutoNumber Field. The next Record will have 101.
If you want "00101", use Format to display the leading zeros.
*However*, the *only* purpose of an AutoNumber Field is to provide
uniqueness to each Record. The actual value allocated to each Record should
NOT be a consideration. In fact, I use AutoNumber as the PK Fields in most
Tables but my users don't see the values of these AutoNumber Fields. The
reason is that AutoNumber Fields will develop gaps, becomes random or even
negative (in replication).
Thus, you should not attach any meaning to the AutoNumber Fields and the
actual values allocated should NOT matter.
If you want some sort of sequence number, create your own "Custom Number
Sequence" (check Google, there were numerous posts previously), rather than
the AutoNumber Field.
