Curious problem with the ID-field in a table

  • Thread starter Thread starter J. S. EDV
  • Start date Start date
J

J. S. EDV

Good morning NG,

the ID-field in an Access table, which should increment every new record,
resets sometimes its auto-value counter to a number which has been already
assigned. When I correct this through a new record which contains an explicit
ID-value, which is higher than the highest which has been assigned, the
allocation of new ID-values seems to work for some records. But after some
new Records the problem occurs again.

Does anybody know a solution for this?

Thanks

Jacek
 
Hallo Allen

Allen Browne said:
This article discusses several possible reasons for this:
Fixing AutoNumbers when Access assigns negatives or duplicate
at:
http://allenbrowne.com/ser-40.html
Click to expand...

Thank you very much for your help. I have installed all service packs and
checked the database with your script. It seems to work now.

Jacek
 
Back
Top