<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px">
<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></BODY></HTML>