autonumbers

  • Thread starter Thread starter Dorcas
  • Start date Start date
D

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

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.
 
Back
Top