Results 1 to 5 of 5

Thread: VB6 help...

  1. #1
    Join Date
    May 2004

    Unanswered: VB6 help...

    Hey everyone, i am getting this error and can't figure out how to trouble shoot.

    Run Time error '-2147467259 (80004005)':
    Key column information is insufficient or incorrect. Too many rows were affected by update.

    ok now when i debug the program it takes me to the recordset update

    plz help.

  2. #2
    Join Date
    Mar 2004
    It looks like the update that you are trying to do does not contain a primary key or unique index which could cause this problem. Make sure your update table has a primary key or unique index.

    If you post your code I can be more precise in my answer.

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    May 2004
    i found the problem. there was a part of the old code that i forgot to delete that was also accessing the db and that was what was giving me probs.

    thanx for the reply

  4. #4
    Join Date
    Aug 2004

    who tell me "run time error'3704'",thanks

    i come from china

  5. #5
    Join Date
    Jul 2003
    Amsterdam, Nederland

    Error codes

    if you go to

    in the shearch type your error code "number"
    and it will show you and explain a little where it goes wrong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts