How to reset database auto number

[TES]

I built my database, and tested it as I went by filling in dummy entries.
Now that I am ready to start using it I can’t find a way to reset the auto
number primary key. Is there a way to do this? Thanks.

 

[Jeff Boyce]

Yes, and don't!

Access Autonumbers are designed to provide unique row identifiers. As such,
they are generally unfit for human consumption.

If you'll describe WHY you think you need to reset the autonumbers, folks
here may be able to offer approaches.

If your situation turns out to be one of those (rare) times when Autonumbers
should be reset, folks here will be able to help with that, too.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rpettis31]

Other than cosmetic reasons I am not sure why you would want to do this
unless you want to just start fresh. I have deleted the table and recreated
it which resets the number.

 

[John W. Vinson]

I built my database, and tested it as I went by filling in dummy entries.
Now that I am ready to start using it I can’t find a way to reset the auto
number primary key. Is there a way to do this? Thanks.

As Jeff says, it's generally pointless to do so. 3122 makes just as good a
meaningless unique identifier as 1 does; and Autonumbers will ALWAYS have gaps
anyway, so you can't and shouldn't expect them to be neat and continuous.

That said... empty the table (delete all records) and Compact the database.
This works for most if not all versions of Access.