Autonumber creating duplicate number

[Autonumber]

MS Access 2003. The Autonumber generated when adding a record is less than
the maximum number in use, resulting in a Duplicate Key error.

This is in a multi-user environment.

 

[Steve Huff]

This is a bug in the Jet engine. Read about it and a fix here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;291162

--Steve Huff
http://www.huffs.us

 

[Wayne Morgan]

See if these articles will help.

http://support.microsoft.com/default.aspx?scid=kb;en-us;884185


http://support.microsoft.com/default.aspx?scid=kb;en-us;291162
http://support.microsoft.com/default.aspx?scid=kb;en-us;247771
http://members.iinet.net.au/~allenbrowne/ser-47.html