Date Range Query kills Access 2003. . Need Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I'm trying to perform a simple query that returns back records for a
specific date range. Upon executing the query, Access crashes. I was
wondering if any one else has experienced this. . and if so, what was done to
repair/work around this.

Many thanks!

SS
 
Man I wish that would've resolved it. I unchecked the corresponding options,
then restarted Access, and it reoccured. Maybe there's another hook
someplace in 2003? Thank you for the info. . .
 
Okay. . I finally found a work-around/solution for me. I don't know if this
will work for others, however I exhausted my efforts trying everything. . .I
re-registered the jet dlls - didn't resolve issue, I disabled the Name Auto
Correct feature - this did not work, I compacted and fixed the db, etc. .
..countless attempts with no resolution. So I finally recreated my db,
recreated my link tables, etc. . .reran the same date range query (exact
syntaxt as before minf you) and Presto! It worked. So it any of you are
having this problem I would suggest that our dbs had just become too corrupt?
Who knows really. . I'm up and running. . .and hope to not have to post this
same problem again. :)

The best luck to you! Cheers!
SS
 
Back
Top