Concurrency Issues after a Delete has occurred in Access

TheMSsForum.com: The Microsoft Software Forum

This is a multi-part message in MIME format.

------=_NextPart_000_0014_01C4DC40.AB537E90
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi I get this error below.
-------------------

An unhandled exception of type 'System.Data.DBConcurrencyException'
occurred in system.data.dll

Additional information: Concurrency violation: the DeleteCommand
affected 0 records.
--------------------

I am using Access and this only happens when I delete data from a
Dataset and then try to Update it back to the BD.

Adding Works Well and Updating is fine, just deleting.

Any Ideas?

Thx



------=_NextPart_000_0014_01C4DC40.AB537E90
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D580193623-06122004>Hi I =
get this error=20
below.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D580193623-06122004>-------------------</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D580193623-06122004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT><SPAN class=3D580193623-06122004>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004>An =
unhandled=20
exception of type 'System.Data.DBConcurrencyException' occurred in=20
system.data.dll</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004>Additional=20
information: Concurrency violation: the DeleteCommand affected 0=20
records.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>--------------------</SPAN></SPAN></FONT></DIV=
>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>I am using Access and this only happens when =
I delete=20
data from a Dataset and then try to Update it back to the=20
BD.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>Adding Works Well and Updating is fine, just=20
deleting.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>Any Ideas?</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>Thx</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D486520223-06122004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D486520223-06122004></SPAN></FONT>&nbsp;</DIV></SPAN></FONT></DIV>=
</BODY></HTML>

------=_NextPart_000_0014_01C4DC40.AB537E90--
Top

Re: Concurrency Issues after a Delete has occurred in Access by Miha

Miha
Tue Dec 07 02:21:03 CST 2004

This is a multi-part message in MIME format.

------=_NextPart_000_01BE_01C4DC3E.12CC52C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Daren,

You are first deleting and then updating? Shouldn't you insert it and =
not update it?


--=20
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com
"Daren Hawes" <Newsgroups@webdesignmagic.com.au> wrote in message =
news:OU1Acz%232EHA.2016@TK2MSFTNGP15.phx.gbl...
Hi I get this error below.
-------------------

An unhandled exception of type 'System.Data.DBConcurrencyException' =
occurred in system.data.dll

Additional information: Concurrency violation: the DeleteCommand =
affected 0 records.
--------------------

I am using Access and this only happens when I delete data from a =
Dataset and then try to Update it back to the BD.

Adding Works Well and Updating is fine, just deleting.

Any Ideas?

Thx


------=_NextPart_000_01BE_01C4DC3E.12CC52C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Daren,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>You are first deleting and then =
updating? Shouldn't=20
you insert it and not update it?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><BR>-- <BR>Miha Markic [MVP C#] - =
RightHand .NET=20
consulting &amp; development<BR>SLODUG - Slovene Developer Users =
Group<BR><A=20
href=3D"http://www.rthand.com">www.rthand.com</A></FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Daren Hawes" &lt;<A=20
=
href=3D"mailto:Newsgroups@webdesignmagic.com.au">Newsgroups@webdesignmagi=
c.com.au</A>&gt;=20
wrote in message <A=20
=
href=3D"news:OU1Acz%232EHA.2016@TK2MSFTNGP15.phx.gbl">news:OU1Acz%232EHA.=
2016@TK2MSFTNGP15.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D580193623-06122004>Hi I =
get this=20
error below.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D580193623-06122004>-------------------</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D580193623-06122004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT size=3D+0><SPAN class=3D580193623-06122004>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D486520223-06122004>An =
unhandled=20
exception of type 'System.Data.DBConcurrencyException' occurred in=20
system.data.dll</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004>Additional=20
information: Concurrency violation: the DeleteCommand affected 0=20
records.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
=
class=3D580193623-06122004>--------------------</SPAN></SPAN></FONT></DIV=
>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>I am using Access and this only happens =
when I delete=20
data from a Dataset and then try to Update it back to the=20
BD.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>Adding Works Well and Updating is fine, =
just=20
deleting.</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>Any Ideas?</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004></SPAN></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D486520223-06122004><SPAN=20
class=3D580193623-06122004>Thx</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D486520223-06122004></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
=
class=3D486520223-06122004></SPAN></FONT>&nbsp;</DIV></SPAN></FONT></DIV>=
</BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_01BE_01C4DC3E.12CC52C0--

Top