Pass through Query Error

[Finedean]

Hi All,
I am trying to run the following (update) pass through Query and I am getting the following error:

ODBC-call failed
[Microsoft-ODBC SQL Server Driver][SQL Server]line1:incorrect syntax near '('.(#170)

The code:
UPDATE (([LINK TABLE SUB FORM] INNER JOIN dbo_CLAIM_MASTERS_VS ON [LINK TABLE SUB FORM].[Claim Number] = dbo_CLAIM_MASTERS_VS.CLAIMNO)
INNER JOIN dbo_VEND_MASTERS_VS ON dbo_CLAIM_MASTERS_VS.VENDOR = dbo_VEND_MASTERS_VS.VENDORID SET [LINK TABLE SUB FORM].VENDID = [dbo_VEND_MASTERS_VS]![VENDORID], [LINK TABLE SUB FORM].VENDORNM = [dbo_VEND_MASTERS_VS]![VENDORNM], [LINK TABLE SUB FORM].STREET = [dbo_VEND_MASTERS_VS]![STREET], [LINK TABLE SUB FORM].Street2 = [dbo_VEND_MASTERS_VS]![STREET2], [LINK TABLE SUB FORM].CITY = [dbo_VEND_MASTERS_VS]![CITY], [LINK TABLE SUB FORM].STATE = [dbo_VEND_MASTERS_VS]![STATE], [LINK TABLE SUB FORM].ZIP = Left([dbo_VEND_MASTERS_VS]![ZIP],5);

Thanks in advance

 

[PHV]

As you use a passthru query you have to write in SQL Server dialect.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GingerR]

I usually just make all my passthru queries

SELECT LODD_RO.DATA_REFRESH.*
FROM LODD_RO.DATA_REFRESH


then make Access queries use that passthru as a source. Then I don't have to deal with problems.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[dhookom]

I think this was answered in another news group or forum. The [LINK TABLE SUB FORM] is an Access table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]