[AccessD] URGENT - Autonumber is CreatingDuplicate Numbers

Charlotte Foust cfoust at infostatsystems.com
Mon Oct 13 16:24:06 CDT 2003


Hen,

The create new table approach always works.   If this bug works like the
original, appending autonumbers is one of the problems--it doesn't in
fact reset the seed properly.  One of the Jet 4 service packs (I think
it was 4) broke it again after O2k SR-1 so that compacting did not reset
the autonumber to the next highest number, although I believe SP7 has
fixed that ... again.

Charlotte Foust

-----Original Message-----
From: Henry Simpson [mailto:hsimpson88 at hotmail.com] 
Sent: Monday, October 13, 2003 12:32 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] URGENT - Autonumber is CreatingDuplicate Numbers


You can use a database.execute "Insert Into..."  to set the autonumber
field 
to the next valid autonumber or just open a table recordset and .addnew 
setting the autonumber field to the next desired number.  That should
reset 
the autonumber again.  Failing that, I'd copy the table with data to a
new 
table, rename the old table and the copy to the old name and change any 
required relationships as required.  When the new table is created, it 
should properly reset the autonumber again.

Hen


>From: "Terri Jarus" <jarus at amerinet-gpo.com>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] URGENT - Autonumber is CreatingDuplicate
Numbers
>Date: Mon, 13 Oct 2003 14:59:30 -0500
>
>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/fileversio
>n/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

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

_______________________________________________
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