How to reset automatically increase field in ms access

Question

Possible duplicate:
how to start counting from 1 after the erase table in access?

Hello everybody

What will be the request in the reset auti_increment field in the MS Access database?

+3

Yugal Jan 25 '11 at 11:36

2 answers

You need to run the Compact and Recovery Database

+6

Robert Jan 25 '11 at 11:40

Tony · Accepted Answer · 2011-01-25T11:39:52+0000

You can easily find this information using Google, here is a link to an MS support article that describes the process:

I did not reproduce the information here because it is lengthy. There seems to be no magic, single command to reset the counter.