How to reset the autoincrement.

I had a master table with all the states data now each state has it own table. I would like to start the autoincrement on each table at 1 and continiue to the end.

Is there a way to do this?

Thanks

Rafael
rcleonAsked:
Who is Participating?
 
dds110Commented:
Sure:

First - Delete the autonumber field
Second - Copy the table to a new table
Third - Delete the original table
Fourth - Add the new autonumber field


If that doesn't work

Copy and paste the table  >> select structure only
write a query to update the new table with the records from the old table WITHOUT the autonumber field

HTH
0
 
Arthur_WoodCommented:
when you create a table, and then create an autonumber field in that table, the autonumber field automatically starts at 0 for each table.  Autonumber fields are NOT global to the entire Database.

Does that answer your question?

AW
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.