Autonumber jumps back

[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?

 

[Allen Browne]

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