Create an Autonumber column in a table

  • Thread starter Thread starter Astello
  • Start date Start date
How do I add an autonumber column to an already existing table?
Click to expand...

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