Hello,
have anyone ever met autonumber field duplication?
Phenomenon: an app. running genarally error-free, sometimes collapses due to
value duplication in autonumber field because seed value fails(decreasing).
As for I am the author, for sure, there are no any VBA code dealing with seed
value adjusting( at least Intentionally). Might it be an error in Jet engine,
or a tricky bug in my program, that leads to such an error like this?
Environment: Acc 2002, Jet 4.0.
The app runs over WindowsServer 2003, Terminal services.
Your help would be appreciated.
Flogyu

It is possible to insert a duplicate value into an autonumber field.

See: Have Autonumber field start from a value different from 1
http://www.mvps.org/access/tables/tbl0005.htm

I suspect that a failure in the application causes the application restart
at a point where the insertion of the record occurs again.

See if this information helps.


--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"flogyu" <(E-Mail Removed)> wrote in message
news:EF5F55D0-C57B-4995-9E97-(E-Mail Removed)...
> Hello,
> have anyone ever met autonumber field duplication?
> Phenomenon: an app. running genarally error-free, sometimes collapses due
> to
> value duplication in autonumber field because seed value
> fails(decreasing).
> As for I am the author, for sure, there are no any VBA code dealing with
> seed
> value adjusting( at least Intentionally). Might it be an error in Jet
> engine,
> or a tricky bug in my program, that leads to such an error like this?
> Environment: Acc 2002, Jet 4.0.
> The app runs over WindowsServer 2003, Terminal services.
> Your help would be appreciated.
> Flogyu
>
>
>

There are several known bugs that cause JET 4 databases (Access 2000, 2002,
and 2003) to generate duplicate autonumbers.

A bad one was fixed in SP7 for JET 4, so you might like to check that you
have SP8. Info:
http://support.microsoft.com/kb/239114

Another issue is discussed in:
http://support.microsoft.com/?id=884185
but the problem is more generic than the kb recognises. Essentially,
executing any append query that specifies the value for the autonumber and
appends data to a linked table is likely to cause the problem.

Another issue includes a failed write that typically occurs if you have a
main form and a subform both bound to the same table.

Importing/converting from an older Access database can also set the Seed
badly.

More info and workarounds in this article:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"flogyu" <(E-Mail Removed)> wrote in message
news:EF5F55D0-C57B-4995-9E97-(E-Mail Removed)...
> Hello,
> have anyone ever met autonumber field duplication?
> Phenomenon: an app. running genarally error-free, sometimes collapses due
> to
> value duplication in autonumber field because seed value
> fails(decreasing).
> As for I am the author, for sure, there are no any VBA code dealing with
> seed
> value adjusting( at least Intentionally). Might it be an error in Jet
> engine,
> or a tricky bug in my program, that leads to such an error like this?
> Environment: Acc 2002, Jet 4.0.
> The app runs over WindowsServer 2003, Terminal services.
> Your help would be appreciated.
> Flogyu

Dear Rob, thank you for immed answering.
I do not understand clearly what you mean. How could an Access app restart
due to a failure w/o any err msg unless terminlal server?
Flogyu

"RobFMS" wrote:

> It is possible to insert a duplicate value into an autonumber field.
>
> See: Have Autonumber field start from a value different from 1
> http://www.mvps.org/access/tables/tbl0005.htm
>
> I suspect that a failure in the application causes the application restart
> at a point where the insertion of the record occurs again.
>
> See if this information helps.
>
>
> --
> Rob Mastrostefano
>
> FMS Professional Solutions Group
> http://www.fmsinc.com/consulting
>
> Software Tools for .NET, SQL Server, Visual Basic & Access
> http://www.fmsinc.com
>
>
> "flogyu" <(E-Mail Removed)> wrote in message
> news:EF5F55D0-C57B-4995-9E97-(E-Mail Removed)...
> > Hello,
> > have anyone ever met autonumber field duplication?
> > Phenomenon: an app. running genarally error-free, sometimes collapses due
> > to
> > value duplication in autonumber field because seed value
> > fails(decreasing).
> > As for I am the author, for sure, there are no any VBA code dealing with
> > seed
> > value adjusting( at least Intentionally). Might it be an error in Jet
> > engine,
> > or a tricky bug in my program, that leads to such an error like this?
> > Environment: Acc 2002, Jet 4.0.
> > The app runs over WindowsServer 2003, Terminal services.
> > Your help would be appreciated.
> > Flogyu
> >
> >
> >
>
>
>

Maybe its better to say...

When the error occurs, is the application retrying the same code it
executed?
If so, then it may be pushing a duplicate autonumber ID into the table.

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"flogyu" <(E-Mail Removed)> wrote in message
news4AEECAB-5981-4CF6-90DA-(E-Mail Removed)...
> Dear Rob, thank you for immed answering.
> I do not understand clearly what you mean. How could an Access app restart
> due to a failure w/o any err msg unless terminlal server?
> Flogyu
>
> "RobFMS" wrote:
>
>> It is possible to insert a duplicate value into an autonumber field.
>>
>> See: Have Autonumber field start from a value different from 1
>> http://www.mvps.org/access/tables/tbl0005.htm
>>
>> I suspect that a failure in the application causes the application
>> restart
>> at a point where the insertion of the record occurs again.
>>
>> See if this information helps.
>>
>>
>> --
>> Rob Mastrostefano
>>
>> FMS Professional Solutions Group
>> http://www.fmsinc.com/consulting
>>
>> Software Tools for .NET, SQL Server, Visual Basic & Access
>> http://www.fmsinc.com
>>
>>
>> "flogyu" <(E-Mail Removed)> wrote in message
>> news:EF5F55D0-C57B-4995-9E97-(E-Mail Removed)...
>> > Hello,
>> > have anyone ever met autonumber field duplication?
>> > Phenomenon: an app. running genarally error-free, sometimes collapses
>> > due
>> > to
>> > value duplication in autonumber field because seed value
>> > fails(decreasing).
>> > As for I am the author, for sure, there are no any VBA code dealing
>> > with
>> > seed
>> > value adjusting( at least Intentionally). Might it be an error in Jet
>> > engine,
>> > or a tricky bug in my program, that leads to such an error like this?
>> > Environment: Acc 2002, Jet 4.0.
>> > The app runs over WindowsServer 2003, Terminal services.
>> > Your help would be appreciated.
>> > Flogyu
>> >
>> >
>> >
>>
>>
>>

Try the Microsoft Knowledge Base articles:

http://support.microsoft.com/kb/209710

and

http://support.microsoft.com/kb/257408

for possible causes and resolutions.

--
HTH
Van T. Dinh
MVP (Access)



"flogyu" <(E-Mail Removed)> wrote in message
news:EF5F55D0-C57B-4995-9E97-(E-Mail Removed)...
> Hello,
> have anyone ever met autonumber field duplication?
> Phenomenon: an app. running genarally error-free, sometimes collapses due
> to
> value duplication in autonumber field because seed value
> fails(decreasing).
> As for I am the author, for sure, there are no any VBA code dealing with
> seed
> value adjusting( at least Intentionally). Might it be an error in Jet
> engine,
> or a tricky bug in my program, that leads to such an error like this?
> Environment: Acc 2002, Jet 4.0.
> The app runs over WindowsServer 2003, Terminal services.
> Your help would be appreciated.
> Flogyu
>
>
>

I have understood now what you ment. The app is huge, compared to usual Acc
apps. The trouble is that no any error report(run time error or sg like
this). I learned duplication from users laments telling some data items
disappeared. Traceing reason, I find duplicates in tables regarding
autonumber. I wrote codes to discover and recover them, restoring seed too. I
have recently put the appl. to wserver 2003 using its terminal services.
Before switching to w2003 Ts, this kind of error has not occured. An error
may occur w/o reporting, if somewhere in code i used (wrong way) error
handling. Now I start to check it, but I am scared of terminal server's
suspected influence.
Flogyu

"RobFMS" wrote:

> Maybe its better to say...
>
> When the error occurs, is the application retrying the same code it
> executed?
> If so, then it may be pushing a duplicate autonumber ID into the table.
>
> --
> Rob Mastrostefano
>
> FMS Professional Solutions Group
> http://www.fmsinc.com/consulting
>
> Software Tools for .NET, SQL Server, Visual Basic & Access
> http://www.fmsinc.com
>
>
> "flogyu" <(E-Mail Removed)> wrote in message
> news4AEECAB-5981-4CF6-90DA-(E-Mail Removed)...
> > Dear Rob, thank you for immed answering.
> > I do not understand clearly what you mean. How could an Access app restart
> > due to a failure w/o any err msg unless terminlal server?
> > Flogyu
> >
> > "RobFMS" wrote:
> >
> >> It is possible to insert a duplicate value into an autonumber field.
> >>
> >> See: Have Autonumber field start from a value different from 1
> >> http://www.mvps.org/access/tables/tbl0005.htm
> >>
> >> I suspect that a failure in the application causes the application
> >> restart
> >> at a point where the insertion of the record occurs again.
> >>
> >> See if this information helps.
> >>
> >>
> >> --
> >> Rob Mastrostefano
> >>
> >> FMS Professional Solutions Group
> >> http://www.fmsinc.com/consulting
> >>
> >> Software Tools for .NET, SQL Server, Visual Basic & Access
> >> http://www.fmsinc.com
> >>
> >>
> >> "flogyu" <(E-Mail Removed)> wrote in message
> >> news:EF5F55D0-C57B-4995-9E97-(E-Mail Removed)...
> >> > Hello,
> >> > have anyone ever met autonumber field duplication?
> >> > Phenomenon: an app. running genarally error-free, sometimes collapses
> >> > due
> >> > to
> >> > value duplication in autonumber field because seed value
> >> > fails(decreasing).
> >> > As for I am the author, for sure, there are no any VBA code dealing
> >> > with
> >> > seed
> >> > value adjusting( at least Intentionally). Might it be an error in Jet
> >> > engine,
> >> > or a tricky bug in my program, that leads to such an error like this?
> >> > Environment: Acc 2002, Jet 4.0.
> >> > The app runs over WindowsServer 2003, Terminal services.
> >> > Your help would be appreciated.
> >> > Flogyu
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>

Thank you Thank you Thank you -

2 days of trying to debug and your code fixed the problem (whatever it was -
it didn't seem to fit into any of your categories)

"Allen Browne" wrote:

> There are several known bugs that cause JET 4 databases (Access 2000, 2002,
> and 2003) to generate duplicate autonumbers.
>
> A bad one was fixed in SP7 for JET 4, so you might like to check that you
> have SP8. Info:
> http://support.microsoft.com/kb/239114
>
> Another issue is discussed in:
> http://support.microsoft.com/?id=884185
> but the problem is more generic than the kb recognises. Essentially,
> executing any append query that specifies the value for the autonumber and
> appends data to a linked table is likely to cause the problem.
>
> Another issue includes a failed write that typically occurs if you have a
> main form and a subform both bound to the same table.
>
> Importing/converting from an older Access database can also set the Seed
> badly.
>
> More info and workarounds in this article:
> Fixing AutoNumbers when Access assigns negatives or duplicates
> at:
> http://allenbrowne.com/ser-40.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "flogyu" <(E-Mail Removed)> wrote in message
> news:EF5F55D0-C57B-4995-9E97-(E-Mail Removed)...
> > Hello,
> > have anyone ever met autonumber field duplication?
> > Phenomenon: an app. running genarally error-free, sometimes collapses due
> > to
> > value duplication in autonumber field because seed value
> > fails(decreasing).
> > As for I am the author, for sure, there are no any VBA code dealing with
> > seed
> > value adjusting( at least Intentionally). Might it be an error in Jet
> > engine,
> > or a tricky bug in my program, that leads to such an error like this?
> > Environment: Acc 2002, Jet 4.0.
> > The app runs over WindowsServer 2003, Terminal services.
> > Your help would be appreciated.
> > Flogyu
>
>
>