Hello, Is it possible to set a field to a datatype of autonumber when there is alreay data in it?
E emerb Jan 25, 2005 #1 Hello, Is it possible to set a field to a datatype of autonumber when there is alreay data in it?
J John Vinson Jan 25, 2005 #3 Hello, Is it possible to set a field to a datatype of autonumber when there is alreay data in it? Click to expand... Nope. If you need to accomplish this change, create a new table with the existing field definitions, but with an Autonumber; then run an Append query to migrate the data from your existing table. John W. Vinson[MVP]
Hello, Is it possible to set a field to a datatype of autonumber when there is alreay data in it? Click to expand... Nope. If you need to accomplish this change, create a new table with the existing field definitions, but with an Autonumber; then run an Append query to migrate the data from your existing table. John W. Vinson[MVP]
