Access and AutoNumber 2

[tjbennett]

How high will an auto number in Access 2000 go? I have a program that auto assigns Serial Numbers (using Auto Number) and it's reaching 99999, will it go beyond 100,000?

 

[MasterRacker]

I believe autonumber is actually a long integer so your max value should be 2,147,483,647.

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[kray4660]

I found an article from Microsoft that says the maximum number for an auto increment is 2,147,483,647. Apparently it is a long integer, so if you started with negative numbers for the auto increments, you could have even more records (not that Access could really handle that many records very well).

I hope this helps.

 

[tjbennett]

Thank you all.