[AccessD] URGENT - Autonumber is Creating Duplicate Numbers

There was a bug in Access 2000 that did not correctly set the seed for
autonumbers when records were appended, including the autonumber value.
That was cured in SR-1.  I've heard of this same problem recently in
another forum but without details.  What version and service pack of
Access are you using and what Jet service pack do you have installed?  

Charlotte Foust

-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com] 
Sent: Monday, October 13, 2003 5:40 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] URGENT - Autonumber is Creating Duplicate Numbers


My Autonumber is creating duplicate number.  Of course, the records
aren't being saved as the Autonumber needs to be unique.  What should I
do and why is this happening?
 
Thanks for any help you can give.
 
Terri Jarus
Director, Contract Support Services
jarus at amerinet-gpo.com
314-542-1902

------------------------------------------------------------------------
---
This email and any files transmitted with it are confidential and
intended solely for the use of the individuals or entities to whom they
are addressed. If you have received this email in error please return 
it to the sender, and erase any copies thereof.

Copyright 2003 AmeriNet 1nc.