[AccessD] URGENT - Autonumber is Creating Duplicate Numbers

MartyConnelly martyconnelly at shaw.ca
Mon Oct 13 14:08:18 CDT 2003


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

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>
> 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/>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: 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



More information about the AccessD mailing list