autonumbers

[Dorcas]

On yesterday I deleted a row from my Access table (row 28)
and I would like to know how to insert the row back in
place to keep my numbering consistent. I want to insert
row 28 into my database.

 

[John Vinson]

On yesterday I deleted a row from my Access table (row 28)
and I would like to know how to insert the row back in
place to keep my numbering consistent. I want to insert
row 28 into my database.

Autonumbers have one purpose, and one purpose ONLY: to provide an
almost-guaranteed unique key. They ARE NOT RECORD NUMBERS; they are
not guaranteed to be sequential; they will always have gaps.

If this behavior isn't acceptable - don't use an Autonumber; instead,
use a Long Integer field and write VBA code to maintain it.

 

[Armen Stein]

Autonumbers have one purpose, and one purpose ONLY: to provide an
almost-guaranteed unique key. They ARE NOT RECORD NUMBERS; they are
not guaranteed to be sequential; they will always have gaps.

If this behavior isn't acceptable - don't use an Autonumber; instead,
use a Long Integer field and write VBA code to maintain it.

I totally agree with John's stern lecture.

However, you can append a record with a particular AutoNumber key value
by using an Append query. This is usually used for converting data into
a new structure while retaining the unique keys, but it would work for
your purpose also.

But as John says, you'll run into gaps eventually, so you might as well
get used to it.