Skip to main content Skip to primary sidebar

Reset Autonumber

Reset Autonumber Field in Access Without Recreating Table

This is going to be a very short and sweet (and saweeeet!!! that you don’t have to delete) post. Have you ever wanted to reset the counter on a autonumber field in Access, but don’t want to delete the table and start over again? SQL Magic to the rescue! Before running the SQL statement below, […]