reset auto

  • Thread starter Thread starter lane55
  • Start date Start date
L

lane55

When I reset autonumber. I delete autonumber from table,
save table without autonumber. Then open table and add new
autonumber field. Perhaps its a bad shortcut but, it works
for me.
 
A downside to what you describe would be if any related (child) tables had
the original autonumber values as foreign keys. If you wipe out the parent
table's autonumbers and create new ones, this orphans the children ... or
worse! If you have a match between a (newly) autonumbered parent and the
same value as the foreign key in the child table, is it even the same
parent?!
 
Back
Top