can someone tell me whats wrong with this SQL statement that works fine in Access, but wont work on my ASP page.

Select *
From Status
Where (Status.Quote_No)=9600003 and (Status.Date) = (Select max(Status.Date) from Status)

im confused as to why that wont work on my ASP page

i get the error on the line that is trying to open the RecordSet with that SQL statement.