Thread
:
values in the AutoNumber field are not sequential, why?
View Single Post
#
2
April 3rd, 2010, 01:08 AM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
Posts: 1,017
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?
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]