Total parameter query and ODBC-call failed

[Ivan]

Hello,

I use Access 2007 as a front-end to a Microsoft SQL 2008 database via an
ODBC connection using SQL Server Native Client 10.0 driver.

If I want to run a total parameter query like this one:

PARAMETERS [Parameter1] Text ( 255 );
SELECT TABLE1.FIELD1, [Parameter1] AS FIELD2, Sum(TABLE1.FIELD3) AS FIELD3
FROM TABLE1
WHERE <some filters>
GROUP BY TABLE1.FIELD1, [Parameter1];

then I get the error message: "ODBC-call failed". TABLE1 is a table from
SQL server.

I don't have any problem using simple select query:

PARAMETERS [Parameter1] Text ( 255 );
SELECT TABLE1.FIELD1, [Parameter1] AS FIELD2, TABLE1.FIELD3
FROM TABLE1
WHERE <some filters>

I get but the same error "ODBC-call failed" if I save first the second query
(for example qrySaved) and run then a new total query:

SELECT qrySaved.FIELD1, qrySaved.FIELD2, Sum(qrySaved.FIELD3) AS FIELD3
FROM qrySaved
GROUP BY qrySaved.FIELD1, qrySaved.FIELD2;

Why? It seems to me that in earlier versions of connections between access
and SQL I didn't have any such difficulty:

Thank you for any assistance and help

Ivan