Erwin Craps
Erwin.Craps at ithelps.be
Tue Oct 14 07:23:09 CDT 2003
You will need to update the SP on your users machine also... -----Oorspronkelijk bericht----- Van: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Namens Terri Jarus Verzonden: maandag 13 oktober 2003 17:49 Aan: accessd at databaseadvisors.com Onderwerp: RE: [AccessD] URGENT - Autonumber is Creating DuplicateNumbers I'm using Access 2002 SP-2. How do I find out what Jet service pack I'm using? Also, I have A97 and, if you can believe it, Access2.0 installed on my computer in different directories. My users are all on Access XP only. To fix the problem in the short term, I copied all my data into a new table allowing the new table to autogenerate the Autonumber field. That seems to have alleviated the problem and allowed the users to put in new records. I just don't want this to happen again. Terri Jarus Director, Contract Support Services jarus at amerinet-gpo.com 314-542-1902 >>> cfoust at infostatsystems.com 10/13/03 10:37AM >>> 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. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031014/937ac7aa/attachment-0001.html>