Pass-Through Queries in 2000 vs 97

[jaywt]

I've been using pass-through queries to an Oracle server successfully in Access 97 for about year. Now I'm trying to convert to 2000 and have run into some puzzling "bugs".

The first is that Access 2000 appears not to return the description of any error message generated by the server and/or Microsoft Oracle for ODBC driver -- if this is simply the way 2000 is constructed, is there a programmatic way to match the ODBC driver error numbers to their descriptions? Or will I have to attempt to generate every possible error in 97 in order to compile a list of error numbers and error descriptions?

The second is that when I convert pass-through queries from 97 to 2000 which use aggregate functions (i.e., sum and group by), I get wildly different results. For example, the following SQL produces clean, sensible results in 97 but astronomical numbers in 2000:

SELECT
OPID,
LOC,
sum(DEACT_FLAG)
FROM TABLE1
WHERE
(DEACT_FLAG > 0)
GROUP BY
OPID,
LOC

In 97, I might get something like:

opid1 loca 5
opid2 loca 4
opid3 locb 1
opid4 locb 6
etc...

Whereas in 2000, I might get something like:

opid1 loca 1093483576
opid2 loca 598490985
opid3 locb 293940492
opid4 locb 2502938566
etc...

Any help would greatly appreciated . . . Many thanks!
Jay