Error unknown by MSDN Please HELP!!!

Article View: be.comp.programming

Article #15611

Back to be.comp.programming Previous Next

#15611

From: Wegra N.V.
Date: Tue, 12 Sep 2000 11:29

30 lines
1916 bytes

Run-time error '-214767259 (80004005)'

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 = "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] = " & Me.wnID _
            & " and [Datum transaktie] = #" & Me.dat & "# order by
[Tijd-van]"
    AdodcEigenTijd.RecordSource = Qry
    AdodcEigenTijd.Refresh
    AdodcEigenTijd.Recordset.MoveLast
    AdodcEigenTijd.Recordset!EndTime = Me.tijd
    AdodcEigenTijd.Recordset.Update
    AdodcEigenTijd.Recordset.Close
End Function



AdodcEigenTijd = link with my database

pOSTmASTEr

Technical Details

Message-ID: <39be13ac$0$4496$73bec57d@news.be.uu.net>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!europa.netcrusader.net!204.71.34.3!newsfeed.cwix.com!skynet.be!newsfeed1.news.nl.uu.net!sun4nl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 110e3b,b845b46743b46b19,start
X-Google-Attributes: gid110e3b,public
X-Google-Thread: fcea4,b845b46743b46b19,start
X-Google-Attributes: gidfcea4,public
X-Google-Thread: 1143a7,b845b46743b46b19,start
X-Google-Attributes: gid1143a7,public
X-Google-ArrivalTime: 2000-09-12 04:29:50 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!europa.netcrusader.net!204.71.34.3!newsfeed.cwix.com!skynet.be!newsfeed1.news.nl.uu.net!sun4nl!not-for-mail
From: "Wegra N.V." <infor@wegra.be>
Newsgroups: be.comp.programming,comp.lang.basic.visual.database,comp.lang.basic.visual.misc
Subject: Error unknown by MSDN Please HELP!!!
Date: Tue, 12 Sep 2000 13:29:35 +0200
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: 32
Message-ID: <39be13ac$0$4496$73bec57d@news.be.uu.net>
NNTP-Posting-Host: uu212-190-8-135.unknown.uunet.be
X-Trace: 968758188 news.be.uu.net 4496 212.190.8.135