Affichage des articles dont le libellé est Corrupted Auto Number - Help!. Afficher tous les articles
Affichage des articles dont le libellé est Corrupted Auto Number - Help!. Afficher tous les articles

Corrupted Auto Number - Help!

mardi 17 février 2015

As part of a larger multi-user system there is a time recording part with a simple table called tblTime with an autonumber field. Today at 11:45 users started reporting receiving a 3022 error. On looking at the table I noticed that if I tried to manually add a record then the ID field number inserted automatically was not the next number in sequence, but one that already existed, hence the error.



Can anyone shed any light on how this might have happened, and what I can do about it?



Can I reset the seed, or what?



Thanks

Dave

Corrupted Auto Number - Help!

Labels