Converting your Number column to AutoNumber

Unfortunately you can’t convert your normal Numeric column to a AutoNumber column if there’s data existing in the table even if the numbers follow a series and are ordered properly.

However, you can do a little trick. Just follow these steps:

  1. Create a new table with an AutoNumber column.
  2. Copy all columns except that Number column from the original table to the new table.
  3. Copy all data of all columns except that Number column from the original table to the new table.
  4. Delete the original table.
  5. Name the new table with the same name as the original table deleted.
  6. Congratulations! You have finished. :)

More advanced solution? Check it out here.

Similar Posts:

Random Posts:

Recent Posts: