I have a table on SQL server 2000 which I link into with Access (2000
format but opened in XP). I've created an Acccess Query and added a
where clause for a date field any date (e.g. #15/Jan/2004#). Upon
clicking the run button access just crahes and shuts down. If I remove
the where it works fine.

I've tried using other date fields (in the where) and the same
problems occurs but I can use filter of non date fiels in the where
clause.

Unfortunately using aview on the SQL server and linking it to Access
it's a possibility since the date in the where is dynamic and wil
change (as it's part of a search screen).



TIA

Colin

Try: ( #15/1/2004#).


"Colin Leahey" <colin_leahey (AT) yahoo (DOT) co.uk> wrote


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.563 / Virus Database: 355 - Release Date: 1/17/2004