Setting last number on a Table.

[Rodolfo Fontes]

Hi group,

Is there possible to set the last autonumbering field of a table?
For example:
I have a table with 10 records, and the last one is number 15, but as
i've deleted some, it starts again on 20. Can i set it to start from 16 ?

Thanks,
Rodolfo Fontes

 

[Rick B]

Why? Autonumber is simply a way to create a unique number in the table. It
should NOT be used for anything that the end user sees in most cases. An
autonumber field is jsut a way of ensuring a unique key in a table.

Do a search on this topic and read the hundreds of previous posts if you
need more details. They explain how to create an incrementing field that
you can use for things like customer number, or invoice number. Many of the
posts explain how gaps WILL occur as records are deleted no matter what
scenario you use. Some of the posts point out that an autonumber is created
as soon as you START to make a new record, so if you ESCape out, you end up
with a missing number.


Rick B

 

[Rick B]

Here are some of those previous posts I mentioned...

http://groups-beta.google.com/groups?q=microsoft.public.access+autonumber+gaps

 

[Guest]

Hi,

Sorry, autonumber fields never go backward, always go forward. So if you
delete a record it will never re-use that record number.

It would require access to do too much overhead as reocrds are deleted to
re-number all the autonumber fields. Thats why it will always be unique.

Frank Stepanski

 

[Joseph Meehan]

Hi,

Sorry, autonumber fields never go backward, always go forward.

They also can go random.