<!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>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></BODY></HTML>