Auto ID number in sequence when one was deleted

[Guest]

In Access how do I get Auto ID Number in sequence when one row was accidently
deleted. Example 1-7 in sequence then it jumps to 9-12 in sequence. Want to
get Auto ID Number 8 back in my Data base table.

 

[Jeff Boyce]

Microsoft Access' Autonumber data type is intended for use as a unique row
identifier. It is unfit for human consumption.

If you are using an Autonumber and expect to have sequential numbers, you
(and your auditors) will be disappointed.

If you have to have sequential numbers, you'll need to create your own
sequential numbering routine (see mvps.org/access for "custom autonumbers").

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Expect it to happen again. Search on comments about why you should not be
using the autonumber. That is the problem in using autonumber for anything
but as a reference number.

Append the records including the autonumber field.

 

[Guest]

You can delete the auto-numbered column, then create it again and everything
will be back in sequential order.