Ok, I changed it...and what happens now is get the following:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '[Title] LIKE 'Broker Appraisal%' AND [EventDate] =#6#'.
/todaysmind/http/main_classes_list_view2.asp, line 25
If you notice, it has [EventDate] = #6#...Well the way I have this setup, is when it runs through the DB...it writes out the class title & eventdate as a parameter on a hyperlink, eg. <a href="class_view_2.asp?title=<%=title%>&eventdate=<%=eventdate%>">
So, when I hover over them, I see the values are getting passed with the link...but when I click I get whats above. And if I change months, i'll get 5 for may, 6 for june & 7 for july...so it looks like the #6# is the eventdate only containing the number of the month.