Reseting number ID

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

Guest

I have a database and everything is fuctioning (thanks to Allen Browne MVP)

now I would like to reset the number ID back to 1 (one)

any suggestions?
 
If you are referring to an AutoNumber field, then remember that the way to
reset the AutoNumber counter back to 1 is to do these two things:

Delete all records from the table.
Compact/Repair the database (Tools -> Database Utilities -> Compact and
Repair Database)
 
Thank you, now my work is complete

Paul M

Brian said:
If you are referring to an AutoNumber field, then remember that the way to
reset the AutoNumber counter back to 1 is to do these two things:

Delete all records from the table.
Compact/Repair the database (Tools -> Database Utilities -> Compact and
Repair Database)
Click to expand...
 
Back
Top