vba error in sql call command
 

I'm getting error # -2147217887, ODBC driver does not support the
requested properties.


My sql command in a vba is summing category information for a range of
invoices. If I limit the range to 50 invoices, I get the data, but over
50 and I get the error.


Any thoughts ???

fwiw I've tested in both Excel 2003 and Excel 2007

Jeff