Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Provided Answers: 5

    Unanswered: The multipart identifier "tablename.fieldname" could not be bound (#4104)

    i have a function in VBA (Access) that passes a sql string into a passthrough query that is server side executed

    table name .fieldname = task_backup.activityid

    I changed the inner joins and left joins to where statements but this particular sql string crashes with the titiled error folowed by the multi-part identifier "task_backup.activityid" could not be bound (#4104) and then it repeats that one more time in the same message
    which i think the second "sub message" is for the null criteria

    can soemone please give me a hand and maybe even a quick guide to converting these joins - I though i was going it text book fashion.

    INSERT INTO NewTasksBeingAdded ( [Activity ID], [WBS Code], [Activity Name], Area, Line)
    SELECT [TASK Excel Data].[Activity ID],[TASK Excel Data].[WBS Code], [TASK Excel Data].[Activity Name], [TASK Excel Data].Area, [TASK Excel Data].Line
    FROM [TASK Excel Data]
    where [TASK Excel Data].[Activity ID] = TASK_BackUP.[Activity ID] and TASK_BackUP.[Activity ID] Is Null
    Dale Houston, TX

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    There is no reference to the table TASK_BackUP, nor in the Destination table (NewTasksBeingAdded ), nor in the source table ([TASK Excel Data]).
    Have a nice day!

Posting Permissions

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