ID number and maximum number of records

[kiufung]

Kindly please advise if there's any restriction in the
number of records MS Access and will the ID no. assigned
be overflowed if maxium no. of records is reached. Thanks.

 

[Allen Browne]

There is no issue with the ID number.

The AutoNumber can theoretically go beyond 2 billion. There is no way you
can fit that many records into a table, when the maximum file size Access
can handle is 2GB.

 

[kiufung]

many thanks.

-----Original Message-----
There is no issue with the ID number.

The AutoNumber can theoretically go beyond 2 billion. There is no way you
can fit that many records into a table, when the maximum file size Access
can handle is 2GB.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks.


.