Access autonumber not incrementing correctly

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi everyone,

i have a problem with a autonumber field.

when it increments is sometimes misses some numbers eg.

1
2
3
4
7
8
11
12
13

I didn't delete records number 5, 6, 9 ,10 neither did I press the escape
key for these records.
Can anyone tell me what the problem is? why access auto number is behaving
like this?

I'm using access 2000 and my database is in a shared environment with 5
users.

Please some help,

Martin.
 
That's the nature of AutoNumber Field. The value is allocated as soon as
you start data entry on the new Record. If the data entry is cancelled, the
value will NOT be recovered and the next new Record entry will start with
another value.

If you need sequential numbering, you should NOT use the AutoNumber Field.
In fact, AutoNumber Field values can become random and even negative if
replication is used. Note that the only purpose of AutoNumber Field is to
provide uniqueness to Records in the Table. Personally, I design the
interface (Forms) so that my users don't see the values of the AutoNumber
Fields.

Check Google on "Custom Nümber Sequence".
 
Back
Top