If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
values in the AutoNumber field are not sequential, why?
While entering records into database, I entered the same record two times. I
deleted the record with the duplicate information and then added a new record. Now the values in the AutoNumber field are not sequential. How can this be? |
#2
|
|||
|
|||
values in the AutoNumber field are not sequential, why?
At the first data entry keystroke of a new record, Access assigns the
autonumber which is the highest existing autonumber +1. Access never goes back and trys to assign a missing autonumber. When you delete a record, Access deletes the assigned autonumber and that number is gone forever never to be reused. Steve "jeffhill" wrote in message ... While entering records into database, I entered the same record two times. I deleted the record with the duplicate information and then added a new record. Now the values in the AutoNumber field are not sequential. How can this be? |
#3
|
|||
|
|||
values in the AutoNumber field are not sequential, why?
Auto numbers are meant to increment, but not necessarily are sequential.
Richard "jeffhill" wrote: While entering records into database, I entered the same record two times. I deleted the record with the duplicate information and then added a new record. Now the values in the AutoNumber field are not sequential. How can this be? |
#4
|
|||
|
|||
values in the AutoNumber field are not sequential, why?
On Fri, 2 Apr 2010 16:49:01 -0700, jeffhill wrote:
While entering records into database, I entered the same record two times. I deleted the record with the duplicate information and then added a new record. Now the values in the AutoNumber field are not sequential. How can this be? That's the way AutoNumbers work. Once a number is assigned to a new record, if you delete that record that number is not re-used. Even without deleting a record, AutoNumbers are only required to be unique, not sequential, and gaps can occur. If, for some reason, you need to have a sequential number, you'll have to create your own system. But again, once you delete a record, let's say record #54 out of a sequence of 1 to 100, you will still have a missing number. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#5
|
|||
|
|||
values in the AutoNumber field are not sequential, why?
In addition to what everyone else has told you, why does it matter?
The only reason for an AutoNumber field is to provide a (practically guaranteed) unique value that can be used as a primary key. 231, 233, 234 serves that need just as well as 1, 2, 3. If the value of the AutoNumber field matters to you, you probably shouldn't be using an AutoNumber field. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "jeffhill" wrote in message ... While entering records into database, I entered the same record two times. I deleted the record with the duplicate information and then added a new record. Now the values in the AutoNumber field are not sequential. How can this be? |
#6
|
|||
|
|||
values in the AutoNumber field are not sequential, why?
=?Utf-8?B?UmljaGFyZA==?= wrote
in news Auto numbers are meant to increment, but not necessarily are sequential. Long integer Autonumbers can be sequential or random. They are sequential by default. They can also be "ReplicationID" instead of long integer, in which case they are neither sequential nor random. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|