I have a table where the key field is an autonumber datatype. Imagine there are five records and someone inadvertantly deleted record number 3. Thus I have records 1,2,4 and 5. Obviously I can't re-enter the deleted record because it would be assigned a number 6. Is ther anyway that I can insert this deleted record?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Auto number record deleted 1
- Thread starter mfd777
- Start date
-
1
- #2
Just because there is a missing number in the autonumber sequence this does not mean that a record was deleted. If a record is started then canceled for any reason, you will loose the autonumber assigned to this cancelled record. This is completely normal. You can not use the autonumber field if you expect it to be sequential with no missing numbers. This is not what this datatype is designed for. It is specifically for assigning a unique identifier for the record entered, and nothing more.
HTH
RDH
Ricky Hicks
rdhicks@mindspring.com
HTH
RDH
Ricky Hicks
rdhicks@mindspring.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question