Autonumber limits

[Chrisopia]

Autonumber is obviously used as a primary key in most cases, but I'm thinking of a future proof version of my application, I already have 6,000 fields and I'm told Autonumber only has room for 4 bytes of data... isn't that 9,999?

What happens after 9,999?

and also how high can it count? (i.e. how many records can a table in Access actually hold)

 

[JANR]

From access help:

Long(Long Integer) are stored as signed 32-bit (4-byte) numbers ranging in value from -2,147,483,648 to 2,147,483,647.

JR

 

[namliam]

Yeah, 4 byte = 4 * 8 bit = 32 bit.

Thus 2 ^ 32 = 4.294.967.296 /2 for neg/pos = 2.147.483.648

My guess is you have a while to go and in reallity, your your database hits ANYWHERE near that number of records you should likely not be using access