ACC: Maximum Number of Rows in Table When Counter Is the Key
ID: Q97520
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
SUMMARY
Novice: Requires knowledge of the user interface on single-user computers.
The maximum value of the Counter data type is the same as the maximum
value of a Long Integer. A Long Integer is 32 bits long and has a
maximum positive value of 2,147,483,647 and a minimum negative value
of -2,147,483,648. If you use a Counter as the primary key, a table
can contain up to four billion records. The maximum number of records
in the table is also limited by the maximum size of a database.
Beginning with Microsoft Access for Windows 95 version 7.0, the Counter
data type is called AutoNumber, which has a NewValue property that enables
you to set the record for either random or increment. If you choose random,
values are assigned as Long Integer. Values in an AutoNumber field
increment from 1 to 2,147,483,647. The next record receives the minimum
negative value for a Long Integer,-2,147,483,648. The AutoNumber value for
each subsequent record is one greater than the previous value, until it
reaches zero.
REFERENCES
For more information about AutoNumber, search the Help Index for "Data
Type," or "DataType property," or ask the Microsoft Access 97 Office
Assistant.
Keywords : kbusage TblDatyp
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbinfo