autonum re-setting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Good on you mate!

Allen Browne said:
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
Click to expand...
 
Back
Top