[AccessD] URGENT - Autonumber is CreatingDuplicate Numbers

William Hindman wdhindman at bellsouth.net
Mon Oct 13 15:11:54 CDT 2003


...you have to go to the Office Update site to get the Jet updates ...HTH :)

William Hindman
<http://www.freestateproject.org> - Do you want liberty in your lifetime?


  ----- Original Message ----- 
  From: Terri Jarus 
  To: accessd at databaseadvisors.com 
  Sent: Monday, October 13, 2003 3:59 PM
  Subject: Re: [AccessD] URGENT - Autonumber is CreatingDuplicate Numbers


  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 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
  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

  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



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031013/fcb3ebeb/attachment-0001.html>


More information about the AccessD mailing list