The AutoNumber field is another specialized Number data type. When an AutoNumber field is added to a table, Access automatically assigns an integer value to the field (beginning at 1) and increments the value each time a record is added to the table. Alternatively (determined by the New Values property), the value of the AutoNumber field is a random integer that is automatically inserted into new records.

Only one AutoNumber field can appear in a table. Once assigned to a record, the value of an AutoNumber field cannot be changed programmatically or by the user. AutoNumber fields are equivalent to the Long Integer data type and occupy 4 bytes, but display only positive values. The range of possible values for AutoNumber fields range from 1 to 4,294,967,296—more than adequate to use as the primary key for most tables.

• Free McAfee Internet Security [This post is written and copyrighted by FIRE Finance (http://firefinance.blogspot.com).]Bank of America is offering FREE McAfee Internet Security for 12...
• The value of photographic prints Stephan R. Lewis is a professional photographer. He accepted to share his knowledge with us, with this exclusive article. The...
• Big Ticket Depot, Big Value Depot Update... The Buzz is starting to get louder and louder for Big Ticket Depot and Big Value Depot. The main office...
• Copy paste textbox First paste all code here in your front end: <script type="text/javascript"> function doact(d){ var doc=eval("document.readme."+d); cp = doc.createTextRange(); cp.execCommand("RemoveFormat"); doc.focus();...
• Successfully Added ListingKey to Loan Table Prosper's public data does not have a primary key foreign key relationship between the loan and listing table.  This keeps...