Re: Error unknown by MSDN Please HELP!!!

Article View: be.comp.programming

Article #15612

Back to be.comp.programming Previous Next

#15612

From: mark
Date: Tue, 12 Sep 2000 13:22

41 lines
2692 bytes

This is caused by one or more rows in your database table containing the
exact same data in all the columns. The easiest solution is to add a counter
column to the table, this ensures that all the rows are unique and can then
be updated or deleted.


"Wegra N.V." <infor@wegra.be> wrote in message
news:39be13ac$0$4496$73bec57d@news.be.uu.net...
> 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: <A2qv5.15683$%l.365378@news-east.usenetserver.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!feed2.onemain.com!feed1.onemain.com!cyclone2.usenetserver.com!news-out.usenetserver.com!cyclone1.usenetserver.com!news-east.usenetserver.com.POSTED!not-for-mail

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 110e3b,b845b46743b46b19
X-Google-Attributes: gid110e3b,public
X-Google-Thread: fcea4,b845b46743b46b19
X-Google-Attributes: gidfcea4,public
X-Google-Thread: 1143a7,b845b46743b46b19
X-Google-Attributes: gid1143a7,public
X-Google-ArrivalTime: 2000-09-12 06:20:30 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!feed2.onemain.com!feed1.onemain.com!cyclone2.usenetserver.com!news-out.usenetserver.com!cyclone1.usenetserver.com!news-east.usenetserver.com.POSTED!not-for-mail
From: "mark" <markjohn21@hotmail.com>
Newsgroups: be.comp.programming,comp.lang.basic.visual.database,comp.lang.basic.visual.misc
References: <39be13ac$0$4496$73bec57d@news.be.uu.net>
Subject: Re: Error unknown by MSDN Please HELP!!!
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <A2qv5.15683$%l.365378@news-east.usenetserver.com>
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
X-Complaints-To: support@usenetserver.com
NNTP-Posting-Date: Tue, 12 Sep 2000 09:18:24 EDT
Organization: WebUseNet Corp  http://www.usenetserver.com - Home of the fastest NNTP servers on the Net.
Date: Tue, 12 Sep 2000 09:22:42 -0400

Reply to Parent Message