how to start counting from 1 after erase table in access ?

[E_Gold]

hi

i have table in access that has an automatic counting in field `ID`

after some insert rows the `id = 200`

i delete the table

i try to insert a new row - and i see that the id start with `201`

how i can force the `id` to start with `1` (without drop the table and make new)

thanks in advance

 

[vbaInet]

Have a read but use with caution.

http://support.microsoft.com/kb/812718
http://www.databasedev.co.uk/reset_autonumber.html

Remember that if you're going to keep related records then it will match the wrong related records with the newly created records if that ID is used in the relationship.

 

[DCrake]

If you simply want to get rid of test data in a table that has an autonumber in it and want it restart numbering at 1 again, then all you need to do is to delete all the records then run a compact and repair. This will reset the autonumber from 1 again.