ID number and maximum number of records

  • Thread starter Thread starter kiufung
  • Start date Start date
K

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.
 
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.
 
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.


.
Click to expand...
 
Back
Top