Resetting Auto number ID column
Posted on 2008-06-15
I don't think this should be a difficult thing to do but I can't seem to figure it out: I have a table in an Access database and because of several script tests, I have a lot of test records that I've had to delete. Even though I've deleted these test records, the autonumber ID column continues to assign the culmulative total of all records ever created i.e. I've run 17 tests, deleted all 17 records, run another test and the autonumber ID column starts number from 18.
How do I reset the autonumber column ID so it starts numbering records from 1 after running and deleting these test records? I hope that was clear and thanks for the help!