Why does microsoft access auto number keep resetting by itself?

Answer

The auto-number data type doesn't reset itself if a table has data in it. But, if a table is empty and you use the compact and repair tool, the table will start back at 1 for the Auto number

Improve Answer Discuss the question "Why does microsoft access auto number keep resetting by itself?" Watch Question

First answer by Sieshw311. Last edit by Sieshw311. Contributor trust: 18 [recommend contributor]. Question popularity: 11 [recommend question]

Research your answer:

Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Why does microsoft access auto number keep resetting by itself?

Our contributors said this page should be displayed for the questions below. (Where do these come from)
If any of these are not a genuine rephrasing of the question, please help out and edit these alternates.
What is the number to microsoft?