Autonumber field

[bboggessswcg]

Is there a way to reset the autonumber field? I would like to wipe my table clean and start the autonumber field as 1 again.

 

[dvannoy]

delete the field...then save the table..go back into the table design and re add the autonumber field..this will set it back to 1

 

[mpastore]

Or just delete all records from table, compact database and it will start from 1 again.

Mike Pastore

Hats off to (Roy) Harper

 

[dvannoy]

mpastore suggestion is another way.. I just hope you dont have any relations on the autonumber field..