Reset Autonumber

  • Thread starter Thread starter Alex P
  • Start date Start date
A

Alex P

Is there any way to reset an autonumber field in Access 2002? I was
testing a form by putting some data in it, the ID number is set to
autoincrement. When I deleted the data the next record started at number
two. I would rather have it start over at number.

Thanks for your help in advance

Alex
 
I might add that normally you should not use an autonumber field
anything you are interested in what the numbers are.

The Access autonumber field is not intended to assure consistent
numbering, only unique numbering. You may well find that the numbers end up
out of order or missing numbers.
 
Back
Top