自动编号 [英] Auto number

问题描述

嗨

i有一个字段，其数据类型为auto number。现在我输入了10条记录。

现在当我删除10条记录时，表现在是空的。当我再次输入1记录autonumber应该从1开始。可能

Hi
i have one field whose datat type is auto number.Now i entered 10 records.
now when i delete 10 records now the table is empty.when i again enter 1 record autonumber should start from 1.can it be possible

推荐答案

我在Access中找到的唯一方法是

1）复制表

2）只粘贴表结构

3）删除orriginal

4）将副本重命名为命名orriginal has

The only way I have found to do it in Access is to
1) copy the table
2) paste the table structure only
3) delete the orriginal
4) rename the copy to the name the orriginal had

嗨。


紧凑/修复将自动编号重置为尽可能低。

如果你使用Autonumber作为主键（这基本上是自动程序适用的东西），然后将数据传输到新表以消除编号间隙的任何技巧。预计会导致关键关系破裂。


亲切的问候，

鱼

Hi.

Compact/Repair will reset Autonumber to the lowest possible.
If you use Autonumber as primary key (which is basically something autonumbers are suited for), then any tricks with transferring data to a new table to "get rid of numbering gaps" are expected to cause broken key relationships.

Kind regards,
Fish

注意，自动编号值不是设计的给出一个连续的数字列表，也不一定从1开始。

Beware, AutoNumber values are not designed to give a contiguous list of numbers, nor necessarily to start from 1.

这篇关于自动编号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！