I haven't had the problem, but here's a
Microsoft KB article on it, with a method
of resetting it. If primary key is also
used in relationships with other tables,
you may have to remove the relationships
while resetting the autonumber.
Should the link be unusable, the article
number is 884185)
http://support.microsoft.com/default...b;en-us;884185
Roy-Vidar
Jay wrote:[color=blue]
> I have a database that uses AutoNum for Customer Number and every[/color]
once[color=blue]
> in a while when entering a new customer the AutoNum goes back and[/color]
uses[color=blue]
> a number already used. So instead of using the next number (say
> 11,150) it'll go back to 10,125 that already has data associated with
> it and it will then count up from there. Has anyone had this problem
> and have a solution for it?[/color]
