Reset autonumber to zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there a method to reset the autonumber back to zero in the tables that contain the autonumber field.I have populated the tables with entries to test it out and now i would like to reset the autonumber.Is this possible?
Thanks for the support!
 
Delete all records from the table, then do a compact and repair.

--
Ken Snell
<MS ACCESS MVP>

joseph said:
Hello,

Is there a method to reset the autonumber back to zero in the tables that
Click to expand...
contain the autonumber field.I have populated the tables with entries to
test it out and now i would like to reset the autonumber.Is this possible?
 
Back
Top