jumping AutoNumber

[bvahan5]

I do use MS Access 2000, tied with web system.
Recently I noticed that auto-numeration is "jumping", i.e. there are records with ID (the name of AutoNumber field) as
4911
4912
4913

and then it jumps to
4917...

skipping 1 or more consequent numbers.

How does AutoNumber work? Are there any internal DBMS reasons, that cause it to skip some numbers?

I want to track the reason of may be disappeared records.

Thanks for advices.

 

[PHV]

As soon as you put the cursor in a new record area an autonumber is assigned to it and is lost if you cancel the creation.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bvahan5]

2 PHV

I can't see these changes, playing with test table.

I place a cursor on the new record line in different places, then check the auto number values - they never jump.

 

[PHV]

Even when you start to type in a new ield and then change your mind and cancel the creation ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Burglar]

It will also skip if you try to insert data programmatically that may violate one or more constraints using dao. For example:

sSql = "insert into table blah blah blah"
dbengine(0)(0).execute (ssql), dbfailoneroor

or if you have warnings turned off so you can't catch the exception.

Burglar

 

[JeremyNYC]

I did a short write up of this on my old website

http://abcdataworks.com/id33.htm

Jeremy

---
Jeremy Wallace
METRIX Lead Developer
Fund for the City of New York
http:// metrix . fcny . org