Posted by Ben on 02/05/07 05:19

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

• Next in forum: Re: Problem: Performance difference between MSDE and SQL Express 2005
• Prev in forum: Re: Using DTS to migrate Access ot SQL Server
• Thread view: "ODBC--call failed" Error

[Reply to this message]