Create an Autonumber column in a table

How do I add an autonumber column to an already existing table?

On 19 Oct 2006 08:38:41 -0700, "Astello" wrote:

How do I add an autonumber column to an already existing table?

If you want to control the sequential order of the autonumber values,
the best solution is to copy your table, *design mode only*, to a new
table; add an autonumber field to the (empty) table, in table design
view; run an Append query to append all the data; drop all
relationships to the old table and build new relationships to the new
one.

John W. Vinson[MVP]

I messed with this table for so long that I'm not even sure what to
tell you I came up with, but I know I had too much data. There were
almost 1 million lines combined, so I put them into notepad (as scrappy
as that sounds) and imported the whole thing at once, letting Access
add the primary key upon import.

John Vinson wrote:
On 19 Oct 2006 08:38:41 -0700, "Astello" wrote:

How do I add an autonumber column to an already existing table?

If you want to control the sequential order of the autonumber values,
the best solution is to copy your table, *design mode only*, to a new
table; add an autonumber field to the (empty) table, in table design
view; run an Append query to append all the data; drop all
relationships to the old table and build new relationships to the new
one.

John W. Vinson[MVP]