G
Guest
Hello,
I'm having a query problem with linked tables in SQL Server 2005.
The query has two tables with the following SQL statement:
SELECT tblCheckStock.ChStPartID, tblCheckStock.MRBLogNo, tblMRBData.Problem
FROM tblCheckStock INNER JOIN tblMRBData ON tblCheckStock.MRBLogNo =
tblMRBData.MRBLogNo
GROUP BY tblCheckStock.ChStPartID, tblCheckStock.MRBLogNo, tblMRBData.Problem
HAVING (((tblCheckStock.ChStPartID)=[Forms]![frmCheckStock]![cboPartID]))
ORDER BY tblCheckStock.MRBLogNo DESC;
As is, I get "ODBC--call failed" error without any error number. If I take
out "GROUP BY" the query works fine.
I'm running XP with msjet40.dll version 4.0.8618.0
I've tried KB303257, but I'm unable to duplicate the problem (i.e. I have no
problem).
Any help is appreciated
Thanx!
Isbjornen
I'm having a query problem with linked tables in SQL Server 2005.
The query has two tables with the following SQL statement:
SELECT tblCheckStock.ChStPartID, tblCheckStock.MRBLogNo, tblMRBData.Problem
FROM tblCheckStock INNER JOIN tblMRBData ON tblCheckStock.MRBLogNo =
tblMRBData.MRBLogNo
GROUP BY tblCheckStock.ChStPartID, tblCheckStock.MRBLogNo, tblMRBData.Problem
HAVING (((tblCheckStock.ChStPartID)=[Forms]![frmCheckStock]![cboPartID]))
ORDER BY tblCheckStock.MRBLogNo DESC;
As is, I get "ODBC--call failed" error without any error number. If I take
out "GROUP BY" the query works fine.
I'm running XP with msjet40.dll version 4.0.8618.0
I've tried KB303257, but I'm unable to duplicate the problem (i.e. I have no
problem).
Any help is appreciated
Thanx!
Isbjornen