<!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.1264" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px"
bgColor=#ffffff>
<DIV><FONT face=Arial size=2>...you have to go to the Office Update site to get
the Jet updates ...HTH :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR><<A
href="http://www.freestateproject.org">http://www.freestateproject.org</A>> -
Do you want liberty in your lifetime?</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jarus@amerinet-gpo.com href="mailto:jarus@amerinet-gpo.com">Terri
Jarus</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, October 13, 2003 3:59
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] URGENT -
Autonumber is CreatingDuplicate Numbers</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>So when I look at the Version, it is msjet40.dll
4.0.6218.0. But when I go to your link to get SP7 - I have to run the <A
class=URLLink href="http://windowsupdate.microsoft.com"
target=_top>http://windowsupdate.microsoft.com</A> which doesn't indicate
that I need any updates relative to Jet??</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I'll have the network dude check it out for me. Thanks
for your help.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Terri Jarus<BR>Director, Contract Support Services<BR><A
href="mailto:jarus@amerinet-gpo.com">jarus@amerinet-gpo.com</A><BR>314-542-1902<BR><BR>>>>
martyconnelly@shaw.ca 10/13/03 02:08PM >>><BR>You can check which
version of jet that goes with msjet40.dll via MS DLL <BR>hell database<BR>but
it is not working at present. So just find dll in windows explorer <BR>and
right double click on it to look at version properties and numbers<BR><BR><A
href="http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp&fp=1">http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp&fp=1</A><BR><BR>So
just get version SP7 below and update ; SP4,5,6 all have
glitches.<BR><BR><A
href="http://support.microsoft.com/?kbid=282010">http://support.microsoft.com/?kbid=282010</A><BR><BR>Files
in Jet 4.0 Service Pack 7<BR>The current release, Jet 4.0 SP7, contains the
following files: File
<BR>Name
Version Size<BR>
-----------------------------------------<BR>
Dao360.dll
3.60.6508.2 561,424<BR>
Expsrv.dll
6.0.72.9589 380,957<BR>
Msexch40.dll
4.0.6807.0 512,272<BR>
Msexcl40.dll
4.0.6726.0 319,760<BR>
Msjet40.dll
4.0.7328.0 1,507,600<BR>
Msjetoledb40.dll 4.0.6807.0
348,432<BR> Msjint40.dll
4.0.6508.0 151,824<BR>
Msjter40.dll
4.0.6508.0 53,520<BR>
Msjtes40.dll
4.0.7328.0 241,936<BR>
Msltus40.dll
4.0.6508.0 213,264<BR>
Mspbde40.dll
4.0.6726.0 348,432<BR>
Msrd2x40.dll
4.0.7328.0 422,160<BR>
Msrd3x40.dll
4.0.6508.0 315,664<BR>
Msrepl40.dll
4.0.6726.0 553,232<BR>
Mstext40.dll
4.0.7328.0 258,320<BR>
Mswdat10.dll
4.0.6508.0 831,760<BR>
Mswstr10.dll
4.0.6508.0 614,672<BR>
Msxbde40.dll
4.0.6726.0 348,432<BR>
Vbajet32.dll
6.0.1.9431 30,749<BR><BR>Some SP version numbers from
some old code that I had to check version <BR>of msjet40.dll directly<BR>You
can have the code if you want to update it.<BR><BR>Case 9 'Access
2000<BR> Select Case
CStr(VerNum)<BR> Case Is =
"4.0.4431.1"<BR>
VerNum = VerNum & " (supplied with Access 2000 Jet
SP5)"<BR> Case Is =
"4.0.3714.7"<BR>
VerNum = VerNum & " (supplied with Access 2000 Jet
SP4)"<BR> Case Is =
"4.00.2927.4"<BR>
VerNum = VerNum & " (supplied with Access 2000 Jet
SP3)"<BR> Case
Else<BR>
VerNum = VerNum & " (supplied with Access 2000, SP
unknown)"<BR> End
Select<BR> Case
Else<BR> VerNum = VerNum & "
(supplied with unknown Access version)"<BR> End
Select<BR><BR>NOTE: Microsoft Jet 4.0 Service Pack 4 (SP4) is included with
Microsoft <BR>Windows 2000 Service Pack 1 (SP1). Microsoft Jet 4.0 Service
Pack 5 <BR>(SP5) is included with Microsoft Windows 2000 Service Pack 2
(SP2).<BR><BR>Terri Jarus wrote:<BR><BR>> I'm using Access 2002 SP-2.
How do I find out what Jet service pack <BR>> I'm using?<BR>>
<BR>> Also, I have A97 and, if you can believe it, Access2.0 installed on
my <BR>> computer in different directories. My users are all on
Access XP only.<BR>> <BR>> To fix the problem in the short term, I
copied all my data into a <BR>> new table allowing the new table to
autogenerate the Autonumber <BR>> field. That seems to have
alleviated the problem and allowed the <BR>> users to put in new
records. I just don't want this to happen again.<BR>> <BR>>
Terri Jarus<BR>> Director, Contract Support Services<BR>>
jarus@amerinet-gpo.com <<A
href="mailto:jarus@amerinet-gpo.com">mailto:jarus@amerinet-gpo.com</A>><BR>>
314-542-1902<BR>><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>> <<A
href="mailto:jarus@amerinet-gpo.com%5D">mailto:jarus@amerinet-gpo.com%5D</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>> <<A
href="http://www.databaseadvisors.com/">http://www.databaseadvisors.com/</A>><BR>><BR>>------------------------------------------------------------------------<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>>
<BR>><BR><BR>-- <BR>Marty Connelly<BR>Victoria,
B.C.<BR>Canada<BR><BR><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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>