What is the data storage size used by AutoNumber data type and what is the range of its possible values
Answers
Answered by
8
Answer:
The data storage size used by Autonumber are equivalent to the Long Integer data type and occupy 4 bytes,but they display only positive values.
The range of its positive values is from 1 to 4,294,967,296—more than adequate as the Primary Key for most tables.
Answered by
2
Explanation:
Answer is AutoNumber- 4 bytes and 16 bytes for Replication ID (GUID)
AutoNumber is a kind of data used in Microsoft Access tables to formula a numeric counter. This number is used to create an identity column which identifies the record of the table. You can have only one AutoNumber is each table. It was called as Counter in Access 2.0.
Similar questions