Auto numbering

  • Thread starter Thread starter Lindac9683
  • Start date Start date
L

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 . . . ???
 
Sure you can. You just can't convert an existing field to an Autonumber
field.
 
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 . . . ???
Click to expand...

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