Auto numbering

[Lindac9683]

After importing all my data into a new Access database, I
decided that I would like to have an autonumber field.
From my reading it appears that you cannot add one after
data is entered in the database. Is there a work
around? Could I set up another database and transfer the
data or . . . ???

 

[Douglas J. Steele]

Sure you can. You just can't convert an existing field to an Autonumber
field.

 

[John Vinson]

After importing all my data into a new Access database, I
decided that I would like to have an autonumber field.
From my reading it appears that you cannot add one after
data is entered in the database. Is there a work
around? Could I set up another database and transfer the
data or . . . ???

Set up your new table, empty, with the autonumber field; then Import
the old table into it.