Autonumber jumps back

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber Already Exists 4
One-to-one relationship 2
2007 Being Weird with AutoNumber 3
Autonumber records inserted in gaps 1
new autonumber values already used in table 2
how to set autonumber primary key combining from several tables 6
AutoNumber, messed up sequence, duplicate values. 2
autonumber in relationship database 2

Top