Hi,

When I using ADO to access a SQL Server table, I got this error:
"Data provider or other service returned an E_FAIL status"

From MS, it points out that when using MS Access ODBC driver, LEFT JOIN and table with boolean column will cause this error.

In my case, I'm accessing SQL Server, also using LEFT JOIN and with boolean field, but only when reach the record with NULL value on some fields (not sure include the boolean field or not). Any idea how to fix it??

Thx a lot!!!