syntax error at or near "{" at character 86(#-1) Second post-More

[Guest]

This is the error message I get when I execute a query with an outer join.

What Access shows in the SQL box:

SELECT
items.item, mfg_vendors.vendor
FROM
items LEFT JOIN mfg_vendors ON items.vendor = mfg_vendors.vendor;


What Access actually sends to the ODBC driver:

SELECT
"items"."item","mfg_vendors"."vendor"
FROM
{oj "items" LEFT OUTER JOIN "mfg_vendors" ON ("items"."vendor" =
"mfg_vendors"."vendor" ) }

 

[Gary Walter]

This is the error message I get when I execute a query with an outer join.

What Access shows in the SQL box:

SELECT
items.item, mfg_vendors.vendor
FROM
items LEFT JOIN mfg_vendors ON items.vendor = mfg_vendors.vendor;


What Access actually sends to the ODBC driver:

SELECT
"items"."item","mfg_vendors"."vendor"
FROM
{oj "items" LEFT OUTER JOIN "mfg_vendors" ON ("items"."vendor" =
"mfg_vendors"."vendor" ) }

Hi Jim,

ODBC driver to what...how...

If you were connecting to a SQL Server
through DSN, I'd look at DSN and make
sure I had

"Use ANSI quoted identifier"

*unchecked*

Apologies for wild guess...

gary