HELP Run-time error '-214767259 (80004005)'

Article View: be.comp.programming

Article #15599

Back to be.comp.programming Previous Next

#15599

From: pOSTmASTEr
Date: Mon, 11 Sep 2000 11:51

34 lines
1751 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: <39bcc72a$0$13954$73bec57d@news.be.uu.net>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-east!sn-xit-uk!supernews.com!194.42.224.136.MISMATCH!diablo.netcom.net.uk!netcom.net.uk!newsfeeds.belnet.be!news.belnet.be!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: fcea4,8be456275190ad99,start
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2000-09-11 04:51:13 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-east!sn-xit-uk!supernews.com!194.42.224.136.MISMATCH!diablo.netcom.net.uk!netcom.net.uk!newsfeeds.belnet.be!news.belnet.be!skynet.be!newsfeed1.news.nl.uu.net!sun4nl!not-for-mail
From: "pOSTmASTEr" <postmaster@wegra.be>
Newsgroups: be.comp.programming
Subject: HELP Run-time error '-214767259 (80004005)'
Date: Mon, 11 Sep 2000 13:51:00 +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: 36
Message-ID: <39bcc72a$0$13954$73bec57d@news.be.uu.net>
NNTP-Posting-Host: uu212-190-4-45.unknown.uunet.be
X-Trace: 968673066 news.be.uu.net 13954 212.190.4.45