Resetting Autonumber Field on command

[Paul H]

I want to reset an autonumber field in a table each time it is populated. Step 1 will be to delete the existing contents. Step 2 will be to append the new records where I want the field to be populated starting with 1. One way would be to delete the data then compact and repair, but I don't want to do this. Everry other way I can think of seems like more of a headache. Here's something that might work. I've created an empty table "x" and written this short procedure.

Private Sub cmdNewTable_Click()
    DoCmd.DeleteObject acTable, "xx"
    DoCmd.CopyObject , "xx", acTable, "x"
End Sub

Now that I see it I sort of like it, but is there another way to simply reset the autonumber in an existing table?

Thanks for listening.

Paul

[drexasaurus]

You can reset the table using ADO and a SQL script. Generally you don't want to reseed auto-incrementing fields, but the need can come up and I get tired of reading other posts asking the user to prove a need.
I don't do it in access myself, but here is an example I found on the SQL script: http://www.utteraccess.com/forum/Res...5#entry2070895
Here is an example of using a column property to do it by allen browne, although he uses it in order to fix a bug: http://allenbrowne.com/ser-40.html

[Paul H]

Thanks for sparing me the lecture (who's got the time) and thanks for the links.