databasems-accessdatabase-designautonumber

Can I edit AutoNumber Column in Access?

I've lost my data in Access base, and I've manage to bring them back but when I copy the values in the table with the AutoNumber Column it increments the numbers. Is there Any way to change it to int and then bring it back to AutoNumber?

Solution

  • I've manage to insert the AutoNumber fields by code from c#. I take all the data I need and just inserted in an empty table.