Curious problem with the ID-field in a table

[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

 

[Allen Browne]

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

 

[J. S. EDV]

Hallo Allen

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

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