Long Integer overflow

[marathonlady]

I have an autonumber field set up as long integer. The field just reached the value of 32670 and I get the overflow message. I thought a long integer
could be much bigger than that before running into that problem.

I got around it by re-creating the field and starting from 1, but would rather
know why it's doing it so I don't have users without their system.

Thanks in advance for any help.

 

[KenHigg]

Is this fld a fk in another table where the fld in that table is a simple integer?

 

[marathonlady]

Overflow fk?

I checked out the other tables that this field is in and it is also set as
long integer, not to say that at one time it may have been an integer.

 

[The_Doc_Man]

If you have underlying VBA code somewhere (form, report, via macro RunCode) and the intermediate variable is Dim'd as Integer rather than Long, that could do it.

 

[marathonlady]

Overflow problem

I checked my VBA code and found in a mod I had a variable defined as
Integer that I moved this field into, but after checking the code closer I find I don't call that routine anywhere. Could it be messing up the field even tho
I don't call the routine?