Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change starting value of autonumber field
- Thread starter mbaddar
- Start date
- Thread starter
- #2
I found a nice way of doing this for anyone that runs
into the same problem. I copied the table whose
identifying number I wanted to autoincrement.
I deleted all the rows from the copied table except
the last one. Then, I changed the datatype of the field
I wanted to increment from autoincrement to number.
After doing this, I appended this table to the original
table.
This did the trick.
MBaddar
into the same problem. I copied the table whose
identifying number I wanted to autoincrement.
I deleted all the rows from the copied table except
the last one. Then, I changed the datatype of the field
I wanted to increment from autoincrement to number.
After doing this, I appended this table to the original
table.
This did the trick.
MBaddar
- Status
Similar threads
- Locked
- Question
- Locked
- Question