Article View: be.comp.programming
Article #15598Run-time error '-214767259 (80004005)' HELP
From: pOSTmASTEr
Date: Mon, 11 Sep 2000 11:48
Date: Mon, 11 Sep 2000 11:48
101 lines
4791 bytes
4791 bytes
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01C01BF6.F5588DA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Run-time error '-214767259 (80004005)'=20
Insufficient or incorrect key column information; too many rows affected =
by update
WHY??? and WHAT IS THE SOLUTION???
My sourcecode:
Private Function EndTime()
Dim Qry As String
Qry =3D "Select [Tijd-van] as Start,[Tijd-tot] as EndTime,[O-ID] as =
Ordernummer,[O-regel-ID] as Regel,[Bewerkings-ID] as Bewerking,[Oms] as =
Omschrijving from [Tikkaart-regel] " _
& "where [Werknemer-id] =3D " & Me.wnID _
& " and [Datum transaktie] =3D #" & Me.dat & "# order by =
[Tijd-van]"
AdodcEigenTijd.RecordSource =3D Qry
AdodcEigenTijd.Refresh
AdodcEigenTijd.Recordset.MoveLast
AdodcEigenTijd.Recordset!EndTime =3D Me.tijd
AdodcEigenTijd.Recordset.Update
AdodcEigenTijd.Recordset.Close
End Function
AdodcEigenTijd =3D link with my database
pOSTmASTEr
------=_NextPart_000_000C_01C01BF6.F5588DA0
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 content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><STRONG><FONT face=3DArial size=3D2>Run-time error '-214767259 =
(80004005)'=20
</FONT></STRONG></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>Insufficient or incorrect key =
column=20
information; too many rows affected by update</STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>WHY??? and WHAT IS THE =
SOLUTION???</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><U>My sourcecode:</U></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Private Function =
EndTime()<BR> =20
Dim Qry As String<BR> Qry =3D "Select [Tijd-van] as=20
Start,[Tijd-tot] as EndTime,[O-ID] as Ordernummer,[O-regel-ID] as=20
Regel,[Bewerkings-ID] as Bewerking,[Oms] as Omschrijving from =
[Tikkaart-regel] "=20
_<BR> =
&=20
"where [Werknemer-id] =3D " & Me.wnID=20
_<BR> =
& "=20
and [Datum transaktie] =3D #" & Me.dat & "# order by=20
[Tijd-van]"<BR> AdodcEigenTijd.RecordSource =3D=20
Qry<BR> AdodcEigenTijd.Refresh<BR> =20
AdodcEigenTijd.Recordset.MoveLast<BR> =20
AdodcEigenTijd.Recordset!EndTime =3D Me.tijd<BR> =20
AdodcEigenTijd.Recordset.Update<BR> =20
AdodcEigenTijd.Recordset.Close<BR>End Function</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>AdodcEigenTijd =3D link with my =
database</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial =
size=3D2>pOSTmASTEr<BR></DIV></FONT></BODY></HTML>
------=_NextPart_000_000C_01C01BF6.F5588DA0--
Technical Details
Message-ID:
<39bcc690$0$13961$73bec57d@news.be.uu.net>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!easynews!bignews.mediaways.net!ams-newsfeed.speedport.net!newsfeed.speedport.net!newsfeeds.belnet.be!news.belnet.be!skynet.be!newsfeed2.news.nl.uu.net!newsfeed1.news.nl.uu.net!sun4nl!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII-7-bit X-Google-Thread: f5f6f,e2453cc9f992305c,start X-Google-Attributes: gidf5f6f,public X-Google-Thread: 110e3b,e2453cc9f992305c,start X-Google-Attributes: gid110e3b,public X-Google-Thread: fcea4,e2453cc9f992305c,start X-Google-Attributes: gidfcea4,public X-Google-Thread: 1143a7,e2453cc9f992305c,start X-Google-Attributes: gid1143a7,public X-Google-ArrivalTime: 2000-09-11 04:48:34 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!easynews!bignews.mediaways.net!ams-newsfeed.speedport.net!newsfeed.speedport.net!newsfeeds.belnet.be!news.belnet.be!skynet.be!newsfeed2.news.nl.uu.net!newsfeed1.news.nl.uu.net!sun4nl!not-for-mail From: "pOSTmASTEr" <postmaster@wegra.be> Newsgroups: be.comp.programming,comp.lang.basic.visual.3rdparty,comp.lang.basic.visual.database,comp.lang.basic.visual.misc Subject: Run-time error '-214767259 (80004005)' HELP Date: Mon, 11 Sep 2000 13:48:25 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C01BF6.F5588DA0" X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Lines: 102 Message-ID: <39bcc690$0$13961$73bec57d@news.be.uu.net> NNTP-Posting-Host: uu212-190-4-45.unknown.uunet.be X-Trace: 968672912 news.be.uu.net 13961 212.190.4.45