multi-part identifier could not be bound

• arash2m

  SSC Enthusiast

  Points: 127

  More actions

  January 23, 2008 at 10:09 am

  #378129

  Hi all,

  I am trying to run a query from ms access which is connected to a ms sql server.

  This is the query:

  SELECTt_user_permissions.user_permissions_id,

  t_users.user_name AS [User],

  q_user_account.user_id,

  t_account.abreviation AS Account,

  q_user_account.account_id,

  t_user_permissions.[read] AS [Read],

  t_user_permissions.write AS [Write]

  FROM ((q_user_account LEFT JOIN t_user_permissions

  ON (q_user_account.account_id=t_user_permissions.account)

  AND (q_user_account.user_id=t_user_permissions.))

  INNER JOIN t_users

  ON q_user_account.user_id=t_users.user_id)

  INNER JOIN t_account

  ON q_user_account.account_id=t_account.account_id

  WHERE q_user_account.user_id In ( 1971342948, 2085812437)

  And q_user_account.account_id <> 0 AND t_users.active=1

  ORDER BY t_users.user_name, t_account.abreviation;

  This query runs great on sql server directly. However, when I try to run this through ms access I get a message saying:

  ODBC call failed. The multi-part identifier "dbo.t_account.account_id" could not be bound.

  I took the "WHERE" clause out and it worked, so I don't exactly know what's happening.

  Thanks

• Ken McKelvey

  SSCoach

  Points: 18939

  More actions

  January 24, 2008 at 3:33 am

  #771193

  Try getting rid of the brackets:

  SELECT P.user_permissions_id

  &nbsp&nbsp&nbsp&nbsp,U.[user_name] AS [User]

  &nbsp&nbsp&nbsp&nbsp,UA.[user_id]

  &nbsp&nbsp&nbsp&nbsp,A.abreviation AS Account

  &nbsp&nbsp&nbsp&nbsp,UA.account_id

  &nbsp&nbsp&nbsp&nbsp,P.[read] AS [Read]

  &nbsp&nbsp&nbsp&nbsp,P.write AS [Write]

  FROM q_user_account UA

  &nbsp&nbsp&nbsp&nbspJOIN t_users U

  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspON UA.[user_id] = U.[user_id]

  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspAND U.active = 1

  &nbsp&nbsp&nbsp&nbspJOIN t_account A

  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspON UA.account_id = A.account_id

  &nbsp&nbsp&nbsp&nbspLEFT JOIN t_user_permissions P

  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspON UA.[user_id] = P.

  WHERE UA.[user_id] IN (1971342948, 2085812437)

  &nbsp&nbsp&nbsp&nbsp AND UA.account_id <> 0

  ORDER BY [User], Account