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

autonumber issue in access 2000 (it's a database backend for webapplication) - seems to increment by 2 sometimes

P: n/a
Hi there

The table in question now has around 25000 records (simple -only 3
columns)

Records are added with a simple insert statement :

INSERT INTO SS_REQUEST_SERVICES ( REQUEST_ID, SERVICE_ID ) values(?,?)

and the autonumber field is incrementet with one. No problem ; - all
running smoothly. Today we had a little problem - and looking into it
it seems that over the last year or so there are about 4 instances
where the gap between 2 IDs are more than 1.

Since the autonumber generated is references in another table, I can
conclude that the number was created as it exists in the other table -
but it has disappeared in the table SS_REQUEST_SERVICES where it was
originally "autogenerated" .

This is one is tough - Has anybody else experienced this - is it a
timing issue, a collision issue, compact repair or ???

cheers
larry
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Autonumbers are not even represented to always be sequential, only to be
unique. They are not reused when the record is deleted. Related records are
only deleted when the "master" is deleted if you have specified "Referential
Integrity" and "Cascading Delete".

I see nothing in your post to indicate that it is not "working as designed",
unless you did specify RI and CD, and they didn't work.

Larry Linson
Microsoft Access MVP
"larry" <ga*********@holger.co.uk> wrote in message
news:76**************************@posting.google.c om...
Hi there

The table in question now has around 25000 records (simple -only 3
columns)

Records are added with a simple insert statement :

INSERT INTO SS_REQUEST_SERVICES ( REQUEST_ID, SERVICE_ID ) values(?,?)

and the autonumber field is incrementet with one. No problem ; - all
running smoothly. Today we had a little problem - and looking into it
it seems that over the last year or so there are about 4 instances
where the gap between 2 IDs are more than 1.

Since the autonumber generated is references in another table, I can
conclude that the number was created as it exists in the other table -
but it has disappeared in the table SS_REQUEST_SERVICES where it was
originally "autogenerated" .

This is one is tough - Has anybody else experienced this - is it a
timing issue, a collision issue, compact repair or ???

cheers
larry

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.