Out of numbers

[roe0]

I have a very large database that houses over 8000 cds.
Each of those cds has between 1 and 100 track listings.
The program assigns the ID number. After I hit 99,999 the
ID numbers ran out (I get 1E+05)and once I hit the
10,000th CD title it will not allow me to assign anymore
log numbers. How can I remedy this? Can I go back and set
it up so that I assign the ID Number and not the program
or is it too late? I don't want to go to another program
as all my libraries reside in access.

Thanks everyone!
Roe

 

[Andrew Smith]

Roe,

1E+05 is just the Access version of scientific notation and it means 10 to
the power of 5 - ie 100,000. If you add one to this so it's 100,001 it will
display as 1E+05 as well - the only reason it's displaying like this is
because there is not enough space to show all the digits. Make the control
or datasheet column wider and all your problems will be over (well this one
will anyway).

You've still got quite a way to go before you reach the real limit - and I
doubt you'd do that if your collection contained all the CDs ever published.

Andrew

 

[Tim Ferguson]

After I hit 99,999 the
ID numbers ran out (I get 1E+05)and once I hit the
10,000th CD title it will not allow me to assign anymore
log numbers. How can I remedy this?

Format the textbox to 000000 or 0000000 etc.

I assume we are talking about Long Integers or Autonumbers here -- I can't
remember off the top of my head how many sig digs you get with a Single,
but a Double will be fine. An ordinary Integer will wrap at 2^15 or approx
16K, and you are already well out of Byte range.

Hope that helps

Tim F