<!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>
<DIV><SPAN class=072551315-13102003><FONT face=Arial color=#0000ff size=2>I
believe thats a bug that has been solved in x or z service
pack...</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=nl dir=ltr align=left><FONT face=Tahoma
size=2>-----Oorspronkelijk bericht-----<BR><B>Van:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>Namens
</B>paul.hartland@fsmail.net<BR><B>Verzonden:</B> maandag 13 oktober 2003
16:15<BR><B>Aan:</B> Access Developers discussion and problem
solving<BR><B>Onderwerp:</B> Re: [AccessD] URGENT - Autonumber is Creating
Duplicate Numbers<BR><BR></FONT></DIV>
<P>Although I can't think how I resolved this issue in the past, I had it
happen quite a few times. What was happening was records we're being
deleted thus leaving gaps in the autonumber field like so</P>
<P>100001</P>
<P>100003</P>
<P>and sometimes when the database was compacted, and a user tried to make a
booking, it would use 100002 and would allow them to complete & save the
booking, but then it would think that the next number in sequence was 100003
and get the same error as yourself.....I'll try and look how I resolved
this</P>
<P>Paul Hartland<BR><BR><BR><BR></P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #ff0000 2px solid">Message
date : Oct 13 2003, 03:10 PM <BR>From : Terri Jarus
<JARUS@AMERINET-GPO.COM><BR>To : accessd@databaseadvisors.com <BR>Copy to :
<BR>Subject : [AccessD] URGENT - Autonumber is Creating Duplicate Numbers
<BR><BR><BR><BR>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR><BR><BR>
<DIV><FONT size=2>My Autonumber is creating duplicate number. Of
course, <BR>the records aren't being saved as the Autonumber needs to be
unique. What <BR>should I do and why is this
happening?</FONT></DIV><BR>
<DIV><FONT size=2></FONT> </DIV><BR>
<DIV><FONT size=2>Thanks for any help you can give.</FONT></DIV><BR>
<DIV> </DIV><BR>
<DIV><FONT size=2>Terri Jarus<BR>Director, Contract Support Services<BR><A
<br>href="mailto:jarus@amerinet-gpo.com">jarus@amerinet-gpo.com</A><BR>314-542-1902</FONT></DIV><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>
<P>---------------------------------------------------------------------------<BR><BR>This
email and any files transmitted with it are confidential and<BR><BR>intended
solely for the use of the individuals or entities to whom they<BR><BR>are
addressed. If you have received this email in error please return <BR><BR>it
to the sender, and erase any copies thereof.<BR><BR><EM><FONT
size=2><BR><BR></FONT></EM><FONT size=2><EM>Copyright 2003 AmeriNet
1nc.</EM></FONT> </P><BR><BR><BR>[ (no filename) (0.2 Kb)
]</BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>