Why does microsoft access auto number keep resetting by itself? |
[Edit] |
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
First answer by Sieshw311. Last edit by Sieshw311. Contributor trust: 18 [recommend contributor]. Question popularity: 11 [recommend question]
|
Research your answer: |
Can you answer other
questions about programming?



