Query to Reset AutoNumber to 1 after full delete

[saigovind]

Please tell me the query to reset autonumber field to 1 after deleting all entries in a table.By searching google i could not get any answers.Please post the answer as soon as posible.Thanks in advance.

[maximus]

After deleting all entries Compact and Repair your Database this will make your auto number to start from 1. To make it start from anyother number of your choice follow the link below check out this thread, Look at the last two post one by Sir Paul and the other by me this is a long one and may be in two pages. Hope this is what you are looking for.
https://www.accessforums.net/forms/a...pens-5235.html