Reseting number ID

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul M - 30 Dec 2005 18:23 GMT

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?

Reply to this Message

Brian - 30 Dec 2005 20:01 GMT

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)

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

Reply to this Message

Paul M - 30 Dec 2005 22:58 GMT

Thank you, now my work is complete

Paul M

> 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:
[quoted text clipped - 8 lines]
> >
> > any suggestions?

Reply to this Message