<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Bericht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px">
<DIV><SPAN class=967532212-14102003><FONT size=1>You will need to update the SP
on your users machine also...</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=nl dir=ltr align=left><FONT
size=2>-----Oorspronkelijk bericht-----<BR><B>Van:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>Namens </B>Terri
Jarus<BR><B>Verzonden:</B> maandag 13 oktober 2003 17:49<BR><B>Aan:</B>
accessd@databaseadvisors.com<BR><B>Onderwerp:</B> RE: [AccessD] URGENT -
Autonumber is Creating DuplicateNumbers<BR><BR></FONT></DIV>
<DIV><FONT size=2>I'm using Access 2002 SP-2. How do I find out what Jet
service pack I'm using?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>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.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>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.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Terri Jarus<BR>Director, Contract Support Services<BR><A
href="mailto:jarus@amerinet-gpo.com">jarus@amerinet-gpo.com</A><BR>314-542-1902</FONT></DIV>
<DIV><BR>>>> cfoust@infostatsystems.com 10/13/03 10:37AM
>>><BR>There was a bug in Access 2000 that did not correctly set the
seed for<BR>autonumbers when records were appended, including the autonumber
value.<BR>That was cured in SR-1. I've heard of this same problem
recently in<BR>another forum but without details. What version and
service pack of<BR>Access are you using and what Jet service pack do you have
installed? <BR><BR>Charlotte Foust<BR><BR>-----Original
Message-----<BR>From: Terri Jarus [<A
href="mailto:jarus@amerinet-gpo.com]">mailto:jarus@amerinet-gpo.com]</A>
<BR>Sent: Monday, October 13, 2003 5:40 AM<BR>To:
accessd@databaseadvisors.com<BR>Subject: [AccessD] URGENT - Autonumber is
Creating Duplicate Numbers<BR><BR><BR>My Autonumber is creating duplicate
number. Of course, the records<BR>aren't being saved as the Autonumber
needs to be unique. What should I<BR>do and why is this
happening?<BR><BR>Thanks for any help you can give.<BR><BR>Terri
Jarus<BR>Director, Contract Support
Services<BR>jarus@amerinet-gpo.com<BR>314-542-1902<BR><BR>------------------------------------------------------------------------<BR>---<BR>This
email and any files transmitted with it are confidential and<BR>intended
solely for the use of the individuals or entities to whom they<BR>are
addressed. If you have received this email in error please return <BR>it to
the sender, and erase any copies thereof.<BR><BR>Copyright 2003 AmeriNet 1nc.
<BR><BR>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com/">http://www.databaseadvisors.com</A><BR></DIV></BLOCKQUOTE></BODY></HTML>