AutoNumbers duplicating

[Adam O'Neil]

Duplicate AutoNumbers are appearing in a table of mine. I've seen a KB
article on this
(http://support.microsoft.com/default.aspx?scid=kb;en-us;291162). The
article recommends getting the latest Jet service pack (8), which I already
have. And I'm still having the problem.

Anyone else seen this?

<sigh>

adam

 

[Allen Browne]

HI Adam.

The service pack is supposed to prevent the problem from occurring. However,
the service pack does not reset the Seed of the Autonumbers if you already
have the problem.

There is code in this link that loops through your tables and resets the
Seed in any table where it is negative or below the maximum value:
http://allenbrowne.com/ser-40.html
If your database is split, run this in the back end.

 

[Adam O'Neil]

Allen, wow! Thanks.

HI Adam.

The service pack is supposed to prevent the problem from occurring. However,
the service pack does not reset the Seed of the Autonumbers if you already
have the problem.

There is code in this link that loops through your tables and resets the
Seed in any table where it is negative or below the maximum value:
http://allenbrowne.com/ser-40.html
If your database is split, run this in the back end.