By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,566 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,566 IT Pros & Developers. It's quick & easy.

Autonumbering

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <rd****@kabelfoon.nl> wrote in message
news:40*********************@news.kabelfoon.nl...
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

Nov 13 '05 #2

P: n/a
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)
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.