Access Auto Number

[woro2006]

I changed the field data type from autonumber to number, but I'd like to change it back. When I tried, I am getting an error.
"Once you enter data in a table, you can't change the data type of any field to AutoNumber, even if you haven't yet added data to that field.

Any ideas?

 

[pbail1]

Delete the row and then insert another. Make that autonumber and problem solved. Well it always works for me.

 

[woro2006]

Yeah, but I removed records from the original table. The ids are not sequentially ordered (1,2,3,5,7,10). If I add a new autonumber, the ids will not match up. I need the autonumber to restart on the last id of the field.

 

[dhookom]

I would create a new table with the same structure except the new table would have the autonumber. Then append the old table into new table. Rename the old table then rename the new table to the old table name.

Duane
Hook'D on Access
MS Access MVP