Can I edit AutoNumber columns in Access?

Question

I lost my data in the Access database and I managed to get it back, but when I copy the values ​​in the table using the AutoNumber column, it increments the numbers. Is there a way to change it to int and then return it to AutoNumber?

Answer 1

I managed to insert AutoNumber fields by code from C #. I take all the data I need and is simply pasted into an empty table.

Answer 2

Here's how I managed to do this in Access 2010:

• Back up your database. (To be safe.)
• "" > "Excel". .
• Excel autonumber.
• "" > "Excel"
  • " " .

. , Excel 65 . .

Answer 3

, . Autonumber , . , SQL.

Autonumber , , . , , - .

Answer 4

? .

, autonumber. , , .

Answer 5

. , . , reset 1. .