autonum re-setting

[NJS]

Good day people.
does anyone know why an autonum field suddenly starts re-using numbers that
were deleted long ago? This table has 9000 records, the first 4000 were
deleted, and all worked fine for years. Then suddenly the system strated
re-using the first 4000?
thank you.

 

[Allen Browne]

There was a problem with an earlier version of JET (usually Acess 2000)
doing this. The problem has been fixed in the service pack. Download SP8 for
JET 4 from:
http://support.microsoft.com/gp/sp

That will prevent the problem recurring, but it won't solve your existing
problem. To do that, copy and run the code from this article:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html

 

[NJS]

Good on you mate!

There was a problem with an earlier version of JET (usually Acess 2000)
doing this. The problem has been fixed in the service pack. Download SP8 for
JET 4 from:
http://support.microsoft.com/gp/sp

That will prevent the problem recurring, but it won't solve your existing
problem. To do that, copy and run the code from this article:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html