Reseting number ID

P

Paul M

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?
 
B

Brian

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)
 
P

Paul M

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...
 
Top