Serious Problem with Date in RecordSource

Tech-Archive recommends: Speed Up your PC by fixing your registry



Anybody knows the reason Access 2003 crashes when I filter data in a form
with a date field?

I’m setting the recordsource to: SELECT Guia.* FROM guia WHERE
Guia.InsertionDate = #7/28/2004#

I also have tried #2004-07-28# but the crash remains.

Table Guia is a linked ODBC table to SQL 2000.

.