Need to Keep Original IDs for new AutoNumber Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 15 Dec 2003 17:54 GMT

Greetings, here is my problem:

I have a table with a Primary_ID field, whose numbers I
wish to retain for historical purposes.

I wish to convert this field into an AutoNumber field, so
any new records will build on these numbers consecutively.

However, Access will not allow any field with existing
data to be converted into an AutoNumber field.

Does anyone have a work-around for this?

Many thanks in advance!
Chris

Reply to this Message

Steve Schapel - 15 Dec 2003 18:47 GMT

Chris,

You will need to make a new blank table with the same structure as the
existing table, except with the Primary_ID field as an AutoNumber
insead of the existing data type, and then use an Append Query to move
the data from the existing table to the new one. This will have the
desired effect.

- Steve Schapel, Microsoft Access MVP

>Greetings, here is my problem:
>
[quoted text clipped - 11 lines]
>Many thanks in advance!
>Chris

Reply to this Message