Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing a number to an autonumber field
- Thread starter RTorrance
- Start date
- Thread starter
- #3
Whoops, misunderstood your question. My bad.
Yep, Access does not like changing a long interger to an autonumber even for an empty table.
If you have linked data in the existing table, I suppose you could add a new field, and give it an autonumber property.
Then you have to go through and reset your links to use the autonumber - a query should work.
Then make the new autonumber the primary key.
Richard
Yep, Access does not like changing a long interger to an autonumber even for an empty table.
If you have linked data in the existing table, I suppose you could add a new field, and give it an autonumber property.
Then you have to go through and reset your links to use the autonumber - a query should work.
Then make the new autonumber the primary key.
Richard
- Status
Similar threads
