Initilize index

[rangasys]

I have ID field data type is auto number
I need to initilize it to zero after deleting all the records.....

tell me a way to do this

 

[Mile-O]

tell me a way to do this

Tell me a way to do this please.

I have ID field data type is auto number
I need to initilize it to zero after deleting all the records.....

Compact your table.

Also, please post to the relevant forum. I have moved this from the Access FAQ forum since that is for specific articles.