auto number

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I have a auto number field which works.
Since I am on the test step, I need reset it while I am testing.

any way to reset to 0.

Thanks in advance,
 
Delete all the records in that table then do a compact and repair.

HOWEVER if you expect autonumbers to be sequential and without breaks, you
may well be disappointed. If used as a primary key, autonumbers are only
guarenteed to be unique. The number could skip a few and, in fact, there are
ways that users could burn through numbers such as opening a new record but
deciding not to complete it.
 
There are ways to do that but I've never bothered to master any of
them. The Autonumber datatype exists for the sole purpose of
generating unique, Long Integer, values to serve as surrogate Primary
Keys. They should not be used to imply any human usable intelligence.
If they are invested with meaning then they are being miss-used. They
should never be seen by the user. They are not guaranteed to be
sequential nor to remain positive.

It's better to spend your development efforts on things that make a
difference.

HTH
 
Back
Top