[AccessD] URGENT - Autonumber is Creating Duplicate Numbers

MartyConnelly martyconnelly at shaw.ca
Mon Oct 13 16:00:18 CDT 2003


I think from the version number you have jet sp-6
Jet sp6 is contained in win 2000 sp-3

here are the download sites for sp7
winxp Jet sp7
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c1780c0-3f8f-4650-b6ad-11badf3f4dab&DisplayLang=en
win2000 jet sp7
http://www.microsoft.com/downloads/details.aspx?FamilyID=c0dbac57-806a-4536-a3ec-3166f06b1cb6&DisplayLang=en

Terri Jarus wrote:

> 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 
> http://windowsupdate.microsoft.com 
> <http://windowsupdate.microsoft.com/> which doesn't indicate that I 
> need any updates relative to Jet??
>  
> I'll have the network dude check it out for me.  Thanks for your help.
>  
>  
> Terri Jarus
> Director, Contract Support Services
> jarus at amerinet-gpo.com <mailto:jarus at amerinet-gpo.com>
> 314-542-1902
>
> >>> martyconnelly at shaw.ca 10/13/03 02:08PM >>>
> You can check which version of jet that goes with msjet40.dll via MS DLL
> hell database
> but it is not working at present. So just find dll in windows explorer
> and right double click on it to look at version properties and numbers
>
> 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>
>
> So just  get version SP7 below and update ;  SP4,5,6 all have glitches.
>
> http://support.microsoft.com/?kbid=282010
>
> Files in Jet 4.0 Service Pack 7
> The current release, Jet 4.0 SP7, contains the following files:    File
> Name           Version        Size
>    -----------------------------------------
>    Dao360.dll          3.60.6508.2    561,424
>    Expsrv.dll          6.0.72.9589    380,957
>    Msexch40.dll        4.0.6807.0     512,272
>    Msexcl40.dll        4.0.6726.0     319,760
>    Msjet40.dll         4.0.7328.0     1,507,600
>    Msjetoledb40.dll    4.0.6807.0     348,432
>    Msjint40.dll        4.0.6508.0     151,824
>    Msjter40.dll        4.0.6508.0     53,520
>    Msjtes40.dll        4.0.7328.0     241,936
>    Msltus40.dll        4.0.6508.0     213,264
>    Mspbde40.dll        4.0.6726.0     348,432
>    Msrd2x40.dll        4.0.7328.0     422,160
>    Msrd3x40.dll        4.0.6508.0     315,664
>    Msrepl40.dll        4.0.6726.0     553,232
>    Mstext40.dll        4.0.7328.0     258,320
>    Mswdat10.dll        4.0.6508.0     831,760
>    Mswstr10.dll        4.0.6508.0     614,672
>    Msxbde40.dll        4.0.6726.0     348,432
>    Vbajet32.dll        6.0.1.9431     30,749
>
> Some SP version numbers from some old code that I had to check version
> of msjet40.dll directly
> You can have the code if you want to update it.
>
> Case 9 'Access 2000
>         Select Case CStr(VerNum)
>         Case Is = "4.0.4431.1"
>             VerNum = VerNum & " (supplied with Access 2000 Jet SP5)"
>         Case Is = "4.0.3714.7"
>             VerNum = VerNum & " (supplied with Access 2000 Jet SP4)"
>         Case Is = "4.00.2927.4"
>             VerNum = VerNum & " (supplied with Access 2000 Jet SP3)"
>         Case Else
>             VerNum = VerNum & " (supplied with Access 2000, SP unknown)"
>         End Select
>     Case Else
>         VerNum = VerNum & " (supplied with unknown Access version)"
>     End Select
>
> NOTE: Microsoft Jet 4.0 Service Pack 4 (SP4) is included with Microsoft
> Windows 2000 Service Pack 1 (SP1). Microsoft Jet 4.0 Service Pack 5
> (SP5) is included with Microsoft Windows 2000 Service Pack 2 (SP2).
>
> Terri Jarus wrote:
>
> > I'm using Access 2002 SP-2.  How do I find out what Jet service pack
> > I'm using?
> > 
> > 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.
> > 
> > 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.
> > 
> > Terri Jarus
> > Director, Contract Support Services
> > jarus at amerinet-gpo.com <mailto:jarus at amerinet-gpo.com>
> > 314-542-1902
> >
> > >>> cfoust at infostatsystems.com 10/13/03 10:37AM >>>
> > There was a bug in Access 2000 that did not correctly set the seed for
> > autonumbers when records were appended, including the autonumber value.
> > That was cured in SR-1.  I've heard of this same problem recently in
> > another forum but without details.  What version and service pack of
> > Access are you using and what Jet service pack do you have installed?
> >
> > Charlotte Foust
> >
> > -----Original Message-----
> > From: Terri Jarus [mailto:jarus at amerinet-gpo.com] 
> <mailto:jarus at amerinet-gpo.com%5D>
> > <mailto:jarus at amerinet-gpo.com%5D>
> > Sent: Monday, October 13, 2003 5:40 AM
> > To: accessd at databaseadvisors.com
> > Subject: [AccessD] URGENT - Autonumber is Creating Duplicate Numbers
> >
> >
> > My Autonumber is creating duplicate number.  Of course, the records
> > aren't being saved as the Autonumber needs to be unique.  What should I
> > do and why is this happening?
> >
> > Thanks for any help you can give.
> >
> > Terri Jarus
> > Director, Contract Support Services
> > jarus at amerinet-gpo.com
> > 314-542-1902
> >
> > ------------------------------------------------------------------------
> > ---
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individuals or entities to whom they
> > are addressed. If you have received this email in error please return
> > it to the sender, and erase any copies thereof.
> >
> > Copyright 2003 AmeriNet 1nc.
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com 
> <http://www.databaseadvisors.com/>
> > <http://www.databaseadvisors.com/>
> >
> >------------------------------------------------------------------------
> >
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com 
> <http://www.databaseadvisors.com/>
> > 
> >
>
> -- 
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 
> <http://www.databaseadvisors.com/>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada





More information about the AccessD mailing list