help changed id to number by mistake how to change back to autonumber

[yepwingtim]

help

i have tables that are relational to this id
________
New jersey dispensary

 

[MSAccessRookie]

help

i have tables that are relational to this id

As you have determined, you will not be able to restore the AutoNumber Property. First, you MUST make a copy of the database, so that if anything else goes wrong, you can start over, and then you will have to consider taking the following steps.

1. Eliminate any gaps in the existing AutoNumbers
   • Open up the table and insert blank records as placeholders for any missing numbers. Mark these records in a unique manner, so that they will be easier to find and remove later.
   • Verify that the old Autonumber Sequence has no gaps.
2. Create a column for the new AutoNumbers
   • Add the column in Design Mode.
   • Opening the Table in DataSheet Mode to show the new AutoNumber Values.
   • Verify that the New Values match the old ones. If they do not, you will need to remove the new AutoNumber Field and redo Step 1 until they match.
3. Established relationships should remain unless original column has been removed.
   • Identify the affected relationships, break the existing links, and establish links to the new column
4. Cleanup the data
   • Remove any placeholder records that were inserted.
   • Rename previous PrimaryID column to save the values
     • Do not remove this column until you are sure the operation is completed successfully
   • Rename the New AutoNum Column to have the same name as the previous PrimaryID column.
   • Verify that the table has been updated successfully.

 

[yepwingtim]

Thanks so much MSAccessRookie - really learned alot from you.

Great help as always =D

Cheers~

-Danielle
________
Medical dispensaries

 

[MSAccessRookie]

Thanks so much MSAccessRookie - really learned alot from you.

Great help as always =D

Cheers~

-Danielle

That was Air Code from the top of my head. Please let us know if the recovery is successful.

 

[yepwingtim]

All I used was an append query - it converted the id back to autonumber

Cheers =D
________
Buy Aromed Vaporizer

 

[MSAccessRookie]

All I used was an append query - it converted the id back to autonumber

Cheers =D

Did you validate that all of the new autonumbers matched the old ones? If there was a gap, the new autonumber would get out of sync.

 

[yepwingtim]

Yes, everything seems fine.

XD
________
Bong pictures