G
Guest
We have an auto number field in a form, we need to restart the sequence from
1, how do you go about doing it?
1, how do you go about doing it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MacDermott
If you are a programmer who needs to reset the sequence before the first
deployment to the public, simply empty out the table and compact the
database.
But in general, you should not be using an auto-number if it matters to you
what the values it returns are.
HTH
Turtle myself
deployment to the public, simply empty out the table and compact the
database.
But in general, you should not be using an auto-number if it matters to you
what the values it returns are.
HTH
Turtle myself
V
Van T. Dinh
Delete all Records in the Table and then Compact the database.
OTOH, the only purpose of AutoNumber Field is to provide uniqueness to each
Record in the Table and the actual value allocated to each Record should not
matter.
AutoNumber values will develop gaps in the sequence, become negative or even
random (in replication). In my applications, users don't even see the
values of AutoNumber Fields for the above reason.
Beware that attaching some meaning to AutoNumber values may create problems
in the database later. If you need to attach some significance to the
values, AutoNumber may not be the correct Field type to use.
OTOH, the only purpose of AutoNumber Field is to provide uniqueness to each
Record in the Table and the actual value allocated to each Record should not
matter.
AutoNumber values will develop gaps in the sequence, become negative or even
random (in replication). In my applications, users don't even see the
values of AutoNumber Fields for the above reason.
Beware that attaching some meaning to AutoNumber values may create problems
in the database later. If you need to attach some significance to the
values, AutoNumber may not be the correct Field type to use.