IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Access autonumber skipping.
Post #46,711
by acagle
7/24/02 11:34:13 AM
Reply
New Access autonumber skipping.

Couldn't find anything on this on the M$ web site. Any idears?



Just to let you know of a database problem that may or may not
come up again. Both Mel and Bev have had one episode of this
where they have had the entry database 'skip' an id number - ie.
patient number 18 was entered, then the next id number that the
database came up with was patient number 20.



I'm thinking maybe it's a result of accidentally double-clicking a button or something.
Post #46,723
by tseliot
Picture of tseliot
7/24/02 12:29:04 PM
Reply
New just a couple first thoughts
1) Access won't re-use an ID. If someone used ID 19, then deleted it, then made a new one, it would be 20. You have to compact the DB to get #19 back, and that's only if you haven't already used #20, etc.

2) multiuser issues?

3) as you say, double-clicking ;)
---------------------------------
Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10
Post #46,731
by acagle
7/24/02 12:59:00 PM
Reply
New Re: just a couple first thoughts
It's single-user, so that's not the problem. I don't believe she knows how to delete records either. And I just tried activley double-clicking the 'New Entry' button and it doesn't do anything untowards.

Buggers.
Post #46,776
by ChrisR
7/24/02 9:16:13 PM
Reply
New Transactions?
Don't know if you're using transactions, but a rollback of a transaction will not have the effect of rolling back the autonumbering.

For example, if the user started to enter a new row (either on purpose or accidentally) but then immediately hit undo or delete (etc...), the autonumber would have been incremented but not rolled back.
     Access autonumber skipping. - (acagle) - (3) - July 24, 2002, 11:34:13 AM EDT
         just a couple first thoughts - (tseliot) - (1) - July 24, 2002, 12:29:04 PM EDT
             Re: just a couple first thoughts - (acagle) - July 24, 2002, 12:59:00 PM EDT
         Transactions? - (ChrisR) - July 24, 2002, 09:16:13 PM EDT

You just don't see sideburns like that anymore!
30 ms