Autonumber jumps back

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

We run a database across a network, with about 20 users.
Our client table has an autonumber primary key that is
currently on about 4000. Sometimes when we go to add a
new client this autonumber jumps back to about 2000 so we
can't add new clients as these numbers have already been
taken up. Is there any way that I can either stop this
from happening or a quick way of getting it back up to
4000 again without having to go into the table
and 'add/escape' 2000 times?
 
This was caused by a bug in the JET 4 engine.
It was fixed several service packs ago.
To prevent it recurring, go to support.microsoft.com, the Downloads section,
and get SP8 for JET 4.

To fix the problems with your existing data, use the code in this link:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://members.iinet.net.au/~allenbrowne/ser-40.html
 
Back
Top