Question autonumbering is duplicating numbers

[erniejay]

My table with an autonumbered ID has started assigning numbers for new records that were already assigned to other records and these numbers are not higher than the highest previous number. It's like the autonumbering process has gone wild. Any ideas why this is happening and how to stop it? I'm using Access 2003 on a Win 7 computer.

 

[boblarson]

See this:
http://allenbrowne.com/ser-40.html

 

[erniejay]

Thanks Bob. That was fast and righton the head. Thanks again.