I have a problem in ALL my queries when I run a specific date range. Access always crashes when I view in Datasheet view. This doesn't occur if it's a parameter query and I am prompted to enter the date range. Eg.
Between #1/01/2006# And #31/12/2007# - This would crash
Between [enter start date] And [enter end date] - This would be OK
Can someone please help!!