Reset Autonumber

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
 
J

Joseph Meehan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber 7
Reset Autonumber 2
Autonumber Macro 3
Autonumber trying to create duplicates 3
autonumber queestion 3
Reset Autonumber? 20
resetting autonumber 2
Creating Sub Item in Access 3

Top