dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Problem updating database w/two tables in VB6

  1. #1
    Jade29 Guest

    Problem updating database w/two tables in VB6


    I'm having a problem updating an Access database with my VB6 application.
    I get this error message when I try to update the table that does not have
    the primary key included in the application:

    "Run-time error '-2147467259 (80004005)': Insufficient key column information
    for
    updating or refreshing"

    The database has two tables, and the primary key on each is called "RouteNumber".
    If I specify to display the value of "RouteNumber" in the appropriate textbox
    from the "Carrier" table, then all of the fields from the "Carrier" table
    update just fine, but the fields from the "Complaints" table do not, and
    visa-versa.

    I've tried using the RouteNumber for both tables in the application, making
    one textbox invisible, but then I get the error message on any textbox I
    try to update.

    Any ideas on the problem? Thanks for any advice.





  2. #2
    Ravi Sankar Guest

    Re: Problem updating database w/two tables in VB6


    Ravi Sankar Wrote <buddha_brs@yahoo.com>

    Hai

    I have seen ur problem.Can u give some more info.Are the two tables with
    the same structure?.are Both tables having route number as a primary key?.
    Send me more details about ur problem.

    ......................................................................



    "Jade29" <LibertyD23@mail2queen.com> wrote:
    >
    >I'm having a problem updating an Access database with my VB6 application.
    > I get this error message when I try to update the table that does not have
    >the primary key included in the application:
    >
    >"Run-time error '-2147467259 (80004005)': Insufficient key column information
    >for
    >updating or refreshing"
    >
    >The database has two tables, and the primary key on each is called "RouteNumber".
    > If I specify to display the value of "RouteNumber" in the appropriate textbox
    >from the "Carrier" table, then all of the fields from the "Carrier" table
    >update just fine, but the fields from the "Complaints" table do not, and
    >visa-versa.
    >
    >I've tried using the RouteNumber for both tables in the application, making
    >one textbox invisible, but then I get the error message on any textbox I
    >try to update.
    >
    >Any ideas on the problem? Thanks for any advice.
    >
    >
    >
    >



  3. #3
    PhilipL Guest

    Re: Problem updating database w/two tables in VB6


    "Ravi Sankar" <buddha_brs@yahoo.com> wrote:
    >
    >Ravi Sankar Wrote <buddha_brs@yahoo.com>
    >
    >Hai
    >
    > I have seen ur problem.Can u give some more info.Are the two tables with
    >the same structure?.are Both tables having route number as a primary key?.
    >Send me more details about ur problem.
    >
    >......................................................................
    >
    >
    >
    >"Jade29" <LibertyD23@mail2queen.com> wrote:
    >>
    >>I'm having a problem updating an Access database with my VB6 application.
    >> I get this error message when I try to update the table that does not

    have
    >>the primary key included in the application:
    >>
    >>"Run-time error '-2147467259 (80004005)': Insufficient key column information
    >>for
    >>updating or refreshing"
    >>
    >>The database has two tables, and the primary key on each is called "RouteNumber".
    >> If I specify to display the value of "RouteNumber" in the appropriate

    textbox
    >>from the "Carrier" table, then all of the fields from the "Carrier" table
    >>update just fine, but the fields from the "Complaints" table do not, and
    >>visa-versa.
    >>
    >>I've tried using the RouteNumber for both tables in the application, making
    >>one textbox invisible, but then I get the error message on any textbox

    I
    >>try to update.
    >>
    >>Any ideas on the problem? Thanks for any advice.
    >>
    >>
    >>
    >>


    Do both fields in your tables have the same data type?

    Philp


  4. #4
    Jade29 Guest

    Re: Problem updating database w/two tables in VB6


    One of the tables has 14 fields and the other has five, and yes, they both
    use RouteNumber as the primary key.

    All of the datatypes are the same in all fields, which is text.

    Thanks for your responses.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center