Change field to AutoNumber when there is info in it.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
Is it possible to set a field to a datatype of autonumber when there is
alreay data in it?
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add autonumber to a large table? 0
convert a number to an autonumber 4
Creating an Autonumber field 2
Autonumber records inserted in gaps 1
Import New Table; Set Primary Key As AutoNumber 3
Autonumbering Query 1
Autonumber 7
Autonumber field 5

Back
Top