database 如何在ms访问中重置自动增量字段
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4793022/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how to reset auto increment field in ms access
提问by Yugal
Possible Duplicate:
how to start counting from 1 after erase table in access ?
可能的重复：
如何在访问擦除表后从 1 开始计数？
Hi all
大家好
What will be the query to reset auti_increment field in MS Access Database?
在 MS Access 数据库中重置 auti_increment 字段的查询是什么？
采纳答案by Tony
You can find this information easily using Google, here's a link to the MS support article which describes the process:
您可以使用 Google 轻松找到此信息，这里是描述该过程的 MS 支持文章的链接：
How to reset an AutoNumber field value in Access
I haven't reproduced the info here as it's lengthy. There does not appear to be a magic, single, command to reset the counter.
我没有在这里复制信息，因为它很长。似乎没有一个神奇的、单一的、重置计数器的命令。
回答by Robert
You need to run "Compact and Repair Database"
您需要运行“压缩和修复数据库”
