Key Autonumber is too low - getting duplicate error

[TedT]

I have a table with about 3600 keys, numbered from 1 to 3600. When I try to enter a new record, the autonumber starts in the 20's. I get an error message about duplicate keys, and I have to cancel. If I try again the autonumber goes up by one, but it will take hours to do this with approximately 3600 tries to get past the highest exisiting key number. Is there a way to make Access reset this?



THis table is linked to a many-to-many table and I can't start over or I will lose all my relationships.

Any ideas?

[RuralGuy]

Have you tried a Compact and Repair yet?

[orange]

You may want to read through this material for assistance with autonumber issues.
http://allenbrowne.com/ser-40.html

[TedT]

Thanks - the Compact and Repair seemed to fix it. Lesson learned.
Ted

[RuralGuy]

Glad we could help.