Re: Autonumber values growing by leaps and bounds?

They will not be used exponentially. You will see gaps occasionally big ones,
but those gaps will not grow as your database grows unless you have some very
strange things going on.
I sure hope you're right on that. That's all I need is for this f'ing
app to run out-a-numbers as a result of something strange that
I probably do have going on. That would be just my luck.

Did you account for the fact that the AutoNumbers will wrap around? They will
not wrap to zero and fill in gaps, but they will wrap around and use all of the
negative numbers that a Long Integer supports.
I was just talking to Jeff Smith about that very thing a few minutes
ago. Its a comfort to know that it will wrap.

Be comforted in the fact that I have never seen a post from an Access user that
had run out of AutoNumbers. You would likely hit the file size limit way before
that happened.
Without doubt, I won't run out of them as the result of the actual
record count. Even the biggest customer will probably have no more
than 50-100 thousand recs over a few years use. But if after a year or
two, I'm wasting them by the millions because of something stupid I
did in the code - its gonna come back to haunt me.

Since no one's ever posted the problem, I'm probably worrying over
nothing. But I hope I never have to face coding to reassign smaller
values to base tables and their related counterparts. That would be
a bear.
.

Relevant Pages

  • Re: Fields awardee Shing-Tung Yau lied in Chinese media about Poincare conjecture proofs attribu
    ... The abstract is strange. ... "This proof should be considered as the crowning achievement of the ... I had not heard of any gaps. ... It seems like a lot of hype. ...
    (sci.math)
  • Re: Mystery word wrap
    ... > with '>' when replying or forwarding. ... when I hit reply something very strange happens. ... one line will wrap within the ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: 2.6.18-rc1-mm2
    ... Wouldn't it be cleaner to wrap this unlikely around ... the top-level ""? ... itself it looks strange, that much is true:) ...
    (Linux-Kernel)
  • Re: Q: sorts key and cmp parameters
    ... will use it straight away, not even bothering to know what that ... strange 'key' argument may be useful for. ... course that argument (and the one about the "gaps" themselves) will of course ...
    (comp.lang.python)
  • Re: Bad mains power - popping mixer
    ... If there's extra room in the ferrite's gap, wrap ... the wire around and through some more times. ... Also helps for lightning protection. ... Strange, but true. ...
    (rec.audio.pro)