Re: Key column information insufficient....ERROR

From: Frank Hickman [MVP] (fhickman_NOSP_at_M_noblesoft.com)
Date: 12/27/04

  • Next message: Vineet: "-2147217864 Row cannot be located for updating." 
    Date: Mon, 27 Dec 2004 12:29:49 -0500

    This means that your Primary Key column either contains duplicate entries,
    which most likely is not the case, or one or more of the fields that make up
    your Primary Key do not all require data in them. Are any of the fields in
    the Primary Key allowed to be null? 

    -- 
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"Ashwin" <chandaranas@eth.net> wrote in message 
news:e2pTpdj6EHA.2016@TK2MSFTNGP15.phx.gbl...
> While updating a recordset pulled from an access table through ADO, I am 
> getting this error:
>
> "Key column information is insufficient... affect multiple records...."
>
> and multiple records get updated with same data.
>
> MSDN is at no help...Any suggestion?
>
> Ashwin
>
  • Next message: Vineet: "-2147217864 Row cannot be located for updating."

    Relevant Pages

    • Sub form Entries
      ... I have a sub form in that there is no unique or primary key, ... stop duplicate entries ... 10 (this is duplicate entry) ...
      (microsoft.public.access.formscoding)
    • Re: Need help in SQL
      ... It's important that 00002 NY is a unique combination, witrh a Primary Key or ... Candidate index on zip+state. ... Duplicate entries would lead to duplicate ...
      (microsoft.public.fox.vfp.queries-sql)
    • Re: How would you prevent duplicate entries in a column in SQL.
      ... Sounds like a good candidate for the primary key. ... > How would you prevent duplicate entries in a column in SQL? ...
      (microsoft.public.inetserver.asp.db)
    • Re: Datagrid left-right scroll problem
      ... Are you using custom GridColumnStyles? ... leaving the primary key column out all together and in your Double-Click ...
      (microsoft.public.dotnet.framework.windowsforms)
    • Re: "Cannot find column" exception
      ... he says uSoft went wrong in maintaining Data View Row State. ... ordinally before the primary key column, or if you don't have a primary key ...
      (microsoft.public.dotnet.framework.adonet)