MS Access 2010 AutoNumber Problem

[jjfaith]

I have an MS Access table with an ID field set to AutoNumber - Long Integer. Even with this field setting the table will not accept records once the ID field reaches 32777. That seem to be the maximum value the table will accept. Does anyone know how to fix this problem since I have many tables with the same setting and could have many more records than 32777. It seems to imply field type Integer but the field type is set to Long Integer.

[ranman256]

That is NOT the max number for long,nor autoNum.
did you try compacting/repair the db?

[ranman256]

Also try ,create a new table. Create all fields again manually. Esp, the auto num.
import from the old data. Autonums should be exactly the same.

[JoeM]

I am assuming that maybe you meant 32767, not 32777, as 32767 is the maximum integer value. If not, and you already have values like 32777, then it is not an Integer/Long Integer issue, as ranman pointed out, 32777 is already a Long Integer.

Is everything contained in this Access database, or is it linking to outside data sources, like SQL?
If so, note that response from Brent Spaulding here: https://social.msdn.microsoft.com/Fo...orum=accessdev

[jjfaith]

Thanks for the quick response.

yes it did have record with value 32777. i am executing queries from Excel VBA. If I run the query to start from the record that failed it runs fine. I will re-run again to see if there may be another issue to look at.

[jjfaith]

Found it! It is actual my Excel counter set to integer not the database that is the problem.