Autonumbering

[Richard]

Hi,

Could anyone help me with the following problem?

I created a database for scientific documents, using the usual AutoNumbering
for creating Document_ID's (primary key). The Document_ID's should thus be
the same as the recordnumbers. Now a strange thing happens: numbering is
fine upto # 326, but then, instead of getting 327 for the next Doc_ID, the
numbering continues suddenly with number 65571! Of course I can't change the
numbering manually because it's an Autonumbered field (and there are several
relationships of course).

Can anyone tell me what is going wrong?

Thanks in advance,

Richard

[Reggie]

Re: Autonumbering

Richard, There's nothing wrong. When records are deleted the autonumbers
are not recovered. It picks up where the last one left off. So, if you
originally had 200 records and the autonumbers were consecutively number 1
to 200 and say you deleted records 100 through 200, the next record you add
will have autonumber of 201. It shouldn't matter to you exactly what the
autonumber is. The only thing it should serve as is a unique identifier for
each record.

--
Reggie

----------
"Richard" <rdgouw@kabelfo on.nl> wrote in message
news:40cb006d$0 $203$58c7af7e@n ews.kabelfoon.n l...[color=blue]
> Hi,
>
> Could anyone help me with the following problem?
>
> I created a database for scientific documents, using the usual[/color]
AutoNumbering[color=blue]
> for creating Document_ID's (primary key). The Document_ID's should thus be
> the same as the recordnumbers. Now a strange thing happens: numbering is
> fine upto # 326, but then, instead of getting 327 for the next Doc_ID, the
> numbering continues suddenly with number 65571! Of course I can't change[/color]
the[color=blue]
> numbering manually because it's an Autonumbered field (and there are[/color]
several[color=blue]
> relationships of course).
>
> Can anyone tell me what is going wrong?
>
> Thanks in advance,
>
> Richard
>
>[/color]

[WindAndWaves]

Re: Autonumbering

Dear Richard

Good news, you can adjust the autonumber. The way to do this is a bit
funny....

You append a record using a query, where you include a number (the one you
want to have next -1) for the ID field.

Next you delete this appended record

Result: access will start counting starting at the number you appended + 1.

- Nicolaas
PS - if you are not sure about this procedure then do not hesitate to ask
(reply to group - not email)