ADO Record Set Error Number -2147467259

Code:
SELECT * From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9
Now if i change this query to either of the below it reults in an error as nothing is puled from the database. Now if i run this query directly in Access, these 2 execute fine:

Code:
SELECT Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9
Or to

Code:
SELECT Distinct Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9
Size is a number (long integer) field.

Err.Number is -2147467259
Err.Description is blank. no description
Err.HelpContext is 5003251

I have increased the script time out and command time out time and still the same thing.