Problem with ASP/Access DB

Hi,

I'm using the following SQL Statementbut i won't work.
I allready tried different types of date (YY/MM/DD and others).
The "date" Filed is formatted as Time/Date Field in Access.

SELECT * FROM <tabelle> WHERE date > '31.12.2006' ORDER BY Datum DESC

Anyone got an idea what might be the problem and how to solve ?

Jens
.