Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    2

    Unanswered: Run-time error 3155 ODBC insert on linked table '???' failed

    I have been using a SQL database with a VB5 frontend for about 5 years.
    Works well. Unfortunately I don't have access to the source code.

    I was tasked with implementing a "job entry" application that will allow a
    restricted list of users to enter jobs in the database. We do not want
    these users to be able to access all the data.

    I created an application in Access 2002 that performs this function
    seemingly quite well. However we now seem to intermittently get a hard
    crash and the error Run-time error 3155 ODBC insert on linked table failed
    when attempting to insert data into a specific table through the VB 5
    frontend. This only happens with certain records. It seems to initiate
    randomly but once it is there it sticks to that record.

    Interesting enough I am doing nothing to that table in Access.I'm not even
    linked to it. I am updating a table that this table references when it
    loads the initial information.

    For examople in the Access application
    I create a job in the tblJobs
    I create a record for each sample in tblSamples depending on the quantity
    specified in tblJobs. Thats all.

    In the VB5 app you enter a form that contains a list of steps for each
    sample. I'l callthis tblSteps.
    Example sample #1 was washed 1/1/2005,
    dried 1/2/2005
    You get the picture.

    If you enter the form and there are no steps assigned to the sample. This
    occurs only after initial creation. A default list of steps is loaded for
    that sample. Sometimes there is no problem. Other times during this action
    the dreaded Run-time error 3155 ODBC insert on linked table '???' failed.

    The VB5 app may be looking at tblSamples during this time but I'm not sure.
    I think VB5 still uses a Jet engine. Otherwise, I don't understand the
    linked table error. Any help would be greatly appreciated.

  2. #2
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303
    I think the primary key or the index field value on the detail table are not exist on master table. thats probably.

    Thanks...

  3. #3
    Join Date
    Feb 2005
    Posts
    2
    Thanks, but I'm pretty sure the primary key is there. The issue seems to be intermittent. Is it possible that network sluggishness could cause such an issue? Anyone?

Posting Permissions

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