how to reset auto increment field in ms access [duplicate]

This question already has answers here: Closed 12 years ago.

Possible D开发者_高级运维uplicate:

how to start counting from 1 after erase table in access ?

Hi all

What will be the query to reset auti_increment field in MS Access Database?

---

You need to run "Compact and Repair Database"

---

You can find this information easily using Google, here's a link to the MS support article which describes the process:

How to reset an AutoNumber field value in Access

I haven't reproduced the info here as it's lengthy. There does not appear to be a magic, single, command to reset the counter.