Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?
autonumber to 134. What happened to cause this, how would I fix it?
-
-
Re: AutoNumber jumps numbering
"Gogo" <eprice@cableon e.netwrote in message
news:d6f05294-1959-44de-b5c0-3862037363a0@u1 2g2000prd.googl egroups.com...1. Adding new records, then deleting them.Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?
2. Begining to add a new record, then "undo-ing"
Fred Zuckerman
-
Re: AutoNumber jumps numbering
Gogo wrote:AutoNumber's only specification is that they be unique. If you haveDatabase has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?
requirements beyond that then don't use an AutoNumber.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Comment
-
Re: AutoNumber jumps numbering
Part of your fix is to Compact the database.
"Fixing" the numbers is a more complex question.
Gogo <eprice@cableon e.netwrote in news:d6f05294-1959-44de-b5c0-
3862037363a0@u1 2g2000prd.googl egroups.com:
Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?Comment
-
Re: AutoNumber jumps numbering
Alan Forsyth <Not@iHome.nzwr ote:
If the BE MDB is in A97 format then compacting will lower the next autonumber value>Part of your fix is to Compact the database.
to 1 higher than the current highest number. However in A2000 the autonumber seed is
only reset to 1 if there are no records in the table and isn't reset to the highest
number present in the table.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Comment
-
Re: AutoNumber jumps numbering
"Tony Toews [MVP]" <ttoews@teluspl anet.netwrote in
news:n1im34t2jb lpo3nncgk7779v0 te30ed7eh@4ax.c om:
Thanks, Tony. Yes, I use A97 and mo, I didn't know about the A2000Alan Forsyth <Not@iHome.nzwr ote:
>>>>Part of your fix is to Compact the database.
If the BE MDB is in A97 format then compacting will lower the next
autonumber value to 1 higher than the current highest number. However
in A2000 the autonumber seed is only reset to 1 if there are no
records in the table and isn't reset to the highest number present in
the table.
>
Tony
behaviour.
Alan
Comment
-
Re: AutoNumber jumps numbering
On May 22, 4:02 am, "Rick Brandt" <rickbran...@ho tmail.comwrote:Using 2003 I've tried compact and repair, no success. You'veGogo wrote:>Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?
AutoNumber's only specification is that they be unique. If you have
requirements beyond that then don't use an AutoNumber.
>
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
mentioned is autonumber to result in unique numbers? I don't
understand how to change ClientIDNumber field to get the correct
autonumbering to return. Help
Comment
-
Re: AutoNumber jumps numbering
On May 22, 4:02 am, "Rick Brandt" <rickbran...@ho tmail.comwrote:Hey Rick: I just figured it out. to get AutoNumbering corrected. IGogo wrote:>Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?
AutoNumber's only specification is that they be unique. If you have
requirements beyond that then don't use an AutoNumber.
>
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
added a new field Client_ID_Numbe r as AutoNumber, deleted the
incorrect field, saved structure and data with this new field. It
worked. Thanks,
Gogo
Comment
-
Re: AutoNumber jumps numbering
In article
<928009c8-419a-4442-b62b-0374b1ce8d00@t1 2g2000prg.googl egroups.com>,
Gogo <eprice@cableon e.netSat, 31 May 2008 17:55:49 writes
Why does it bother you that numbers are missing?>On May 22, 4:02 am, "Rick Brandt" <rickbran...@ho tmail.comwrote:>>Gogo wrote:>>Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?
>AutoNumber's only specification is that they be unique. If you have
>requirements beyond that then don't use an AutoNumber.
>>
>--
>Rick Brandt, Microsoft Access MVP
>Email (as appropriate) to...
>RBrandt at Hunter dot com
>Using 2003 I've tried compact and repair, no success. You've
>mentioned is autonumber to result in unique numbers? I don't
>understand how to change ClientIDNumber field to get the correct
>autonumberin g to return. Help
Every time you start a new record (the pencil mark appears in the record
selector) and you then cancel by pressing Escape, you lose a number.
Rick is saying that the specification of an Autonumber is that it is
unique and there is no guarantee there will not be gaps.
In practice, if you specify an AN as type "Increment" it should increase
one by one, but it is very easy to lose numbers - but so what?
--
Les Desser
(The Reply-to address IS valid)
Comment
-
Re: AutoNumber jumps numbering
"Gogo" <eprice@cableon e.netwrote
On May 22, 4:02 am, "Rick Brandt" <rickbran...@ho tmail.comwrote:>Gogo wrote:Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?AutoNumber's only specification is that they be unique. If you have
requirements beyond that then don't use an AutoNumber.
Rick Brandt, Microsoft Access MVPHey, Gogo...Hey Rick: I just figured it out. to get AutoNumbering corrected. I
added a new field Client_ID_Numbe r as AutoNumber, deleted the
incorrect field, saved structure and data with this new field. It
worked. Thanks, Gogo
No, you did NOT figure it out. Knowledgeable people have explained to you,
over and again, that Autonumbers (even using "Increment" ) are not
_specified_ to be monotonically increasing. How many times do they have to
repeat it before you understand that you have recreated a series without the
gaps, but you have not "corrected the problem" BECAUSE THERE WAS NOT A
PROBLEM?
Autonumbers are for internal use as surrogate keys, and for joining related
tables. They are not for display to humans, because of what you
experienced. And, the probability is very high that you will experience it
again.
If you are using Autonumbers as surrogate keys, and you have more than a
'flat file' design, those numbers will appear in related tables as Foreign
Keys. So what's happened to the linkage between your main table where you
arbitrarily replaced the Field and any related tables that used the original
Field (where you saw the gap) as Foreign Key? You certainly did not say
that you'd done anything to "fix" those Foreign Keys.
They say, "What a tangled web we weave when first we practice to deceive,"
but the same applies to "What a tangled web we weave when we insist on
something being what it is NOT, and then resort to workarounds to try to
make it so."
Give it up, Gogo, baby. And, don't come back here whining when you find
another gap in your "carefully fixed Autonumber" -- which you certainly will
in the circumstances others have described, and in some others not so
well-defined and publicized.
Larry Linson
Microsoft Office Access MVO
Comment
Comment