Posted by AlterEgo on 02/05/07 17:52

Ben,

The error is not very intuitive. You might want to try a SQL Trace and an
ODBC trace to get more information. Profiler has an Errors and Warnings /
Exception event you can trace, and the following link will show you how to
set up an ODBC trace:

http://support.microsoft.com/kb/274551

-- Bill

"Ben" <pillars4@sbcglobal.net> wrote in message
news:C7zxh.71351$qO4.32683@newssvr13.news.prodigy.net...
> Hi!
> It has been weeks now that I have been trying to fix an error that I
> encounter everytime it gets to the code at runtime:
>
> SQLStmt = "SELECT Sum([Quantity in Stock]) As TotalInStock,
> Sum([Cost] * [Quantity in Stock]) AS TotalCost " & _
> "FROM [Inventory Products] WHERE [Item
> Number] = '" & ItemNum & "'"
>
> Set InvP = CurDB.OpenRecordset(SQLStmt, DB_OPEN_DYNASET)
> ' ==>> it gets the error here
>
> I tried also to implement the same code using ADODB but still go the same
> error: "ODBC--call failed".
> There are other events where similar code is executed without any problems
> at all.
> Any guidance would be helpful.
>
>
> Thanks
>

[Back to original message]